How do you make a scatter plot from this excel file about cancer rate and age?

Are you using the Scatter Chart? I assume you want to represent the sums of each age group, grouped by part and then by year. If so, try adding the date to the X axis, the sum of the age groups to the Size field, and the part to the Break By field. You could also add part to the Y axis ... it depends how you want to visualize it. I hope this is helpful!

One thing I've picked up along the way I thought I would share is that it is often beneficial to start your widget as a pivot, get the data to look how you want it to look, and then switch the widget type to the more visual type. This doesn't always work, and didn't work for Scatter Chart, but it has helped me a lot in other scenarios. 

Let us know how it goes!