Scatter Plot not showing all data points

Hi Everyone,

I created a scatter plot based on a table with 25 data coordinates but (1) only 16 coordinates are showing in the scatter plot and (2) some of the labels on the scatter plot aren't showing. Does anyone know how I can fix this? Images are below. Here's some other information that might be useful:

- I'm using Excel for Mac 2019 (standalone version).
- The scatter plot is based on columns C and E.
- I can confirm that the scatter plot is linked to the entire set of cells of data.
- I tried searching online for solutions to this problem but just can't seem to find any.

Thanks for your suggestions and let me know if there's any other information I can provide.

Screen Shot 2019-09-16 at 3.11.05 PM.pngScreen Shot 2019-09-16 at 3.11.25 PM.pngScreen Shot 2019-09-16 at 3.12.01 PM.png

Thanks for the update and you're right that not all points would show on the plot since some aren't unique - I forgot about that. I didn't think about that because the data labels would usually overlay one another for overlapping data points and it wasn't the case this time. I'm not sure why and perhaps that's the real problem to solve. I've attached a sample file.

I don't think I deleted/added rows so I'm not sure that explains it. I'm happy to hear your thoughts on the file I uploaded.

Originally Posted by Andy Pope

The data labels appear to be linked to range =PowerInterest!$B$6:$B$40
Where as it should be =PowerInterest!$B$53:$B$88

Thanks Andy - how do you link the data labels to a specific range? I've googled it and see how to do it on Excel for Windows, but I'm on a Mac and am not seeing an option to do that. Am I missing something? The picture below is what I see what I select "Format Data Labels" in Excel for Mac 2019.
Attachment 641760

Whoa... I have exactly the same issue, and actually also with a stakeholder chart...

In my case, I have various columns, including:

Group, Name, X, Y

Some of the values do have unique Name, X and Y. But the labels don't plot.

One thing is currently not all names have values. That seemed to be one of the reasons. But, fiddling around with the data table I realized it was sorted by Group. The moment I sorted it by Name, all labels appeared on the chart. Weird.