how to change axis labels to text?

  • Thread starter frustratedgeochemist
  • Start date
F

frustratedgeochemist

Please help!! i am making scatter plot charts with element names (e.g. SiO2)
along the x-axis but the programme has put all the x-axis labels as a series
of numbers (1, 2...etc.)
How do i change this back??
 
A

Andy Pope

Hi,

XY scatter chart will only display numbers on the axes.
A line chart will display categories on the X Axis.

If you are using a Line chart use the Source Data dialog to specify the
range containing category labels. Right click chart and pick Source data
from context menu.

See here for more detail on the differences between Line and xy-scatter
charts.
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html

Cheers
Andy
 
F

frustratedgeochemist

Andy, you are a genius!!! thank you!

Andy Pope said:
Hi,

XY scatter chart will only display numbers on the axes.
A line chart will display categories on the X Axis.

If you are using a Line chart use the Source Data dialog to specify the
range containing category labels. Right click chart and pick Source data
from context menu.

See here for more detail on the differences between Line and xy-scatter
charts.
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html

Cheers
Andy
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use text descriptors as Y axis units 1
How to getting text labels to show up in scatter chart. 0
Customised Axis Values 2
Extending The Horiz. Axis Question ? 2
change chart primary horizontal axis label or name 1
Secondary axis not aligning to X axis 1
Position of X axis labels 4
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1

Top