Basic Chart Help

[alethea2000]

This should be so simple but i haven't done charts for years and now trying to help my daughter do a chart. They have been told to do a scatter chart but I don't know if this is the right one.

this is the data.

Along the bottom of the chart she wants it to show income and down the site she wants the mortality figures. the the dots on the graph represents a country so brazil would be at 13.5 along the left and 14300 along the bottom. does this make sense to anyone!!!

COUNTRY	INCOME	MORTALITY RATE
Brazil	14300​	13.5​
Nigeria	5300​	117​
Singapore	90100​	2.7​
Moldova	6720​	15.3​
Bahrain	42000​	6.89​
Zambia	3700​	56.1​
Sweden	47200​	2.62​
Qatar	113000​	6.66​
El salvador	7510​	13.1​
New Zealand	36500​	5.61This​

 

[alethea2000]

from what I can see in a scatter chart I would just highlight columns B and C but then the dots would not correlate back to the country

 

[AhoyNC]

Maybe this link on adding data labels to scatter chart will help.

How to improve your Excel Chart

What's on this page Custom data labels Improve your X Y Scatter Chart with custom data labels How to apply custom data labels in Excel 2013 and lat

www.get-digital-help.com