X Axis?

[tt_Gyrl]

I'm trying to create a graph where my X Axis list various contries. For some
reason my X axis is reading as numbers instead of countries. The source data
is pulling from the correct cells where I listed the countries. Can someone
tell me how I can fix it?? Thanks.

 

[Bernard Liengme]

Line or Column chart?
Can't be an XY since that need numbers for the x-axis.
best wishes

 

[tt_Gyrl]

Hi Bernard-
It's a scattered chart. I'm trying to duplicate a chart in a magazine using
the same data. Everything looks good but I need to change the X Axis labels
to read the countries. Help? Thanks.

 

[Bernard Liengme]

An XY (Scatter) chart needs numeric data in x-values
Change it to a Line chart by right clicking and opening Chart Type dialog
A Line chart does no have to have a line - it can have just markers
best wishes

 

[tt_Gyrl]

Bernard...it worked! You're a genius! Thanks.

Mary Ann

 

[Bernard Liengme]

I'll tell that to wife next time I burn the toast.
Thanks