XL2003 - Changing X-axis labels in XY Scatter...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a chart where the X-axis uses custom labels. There are
6 data series arranged in columns; column A contains the following:
1,2,3,E,3,2,1,2,3,E,3,2,1. I would like to use these as my X-axis labels
instead of the default which is 0 - 14 (corresponding to the number of
items). Any ideas?
TIA
Amanda
 
Birmangirl said:
I am trying to create a chart where the X-axis uses custom labels. There are
6 data series arranged in columns; column A contains the following:
1,2,3,E,3,2,1,2,3,E,3,2,1. I would like to use these as my X-axis labels
instead of the default which is 0 - 14 (corresponding to the number of
items). Any ideas?
Click to expand...

Change the chart type to XY (scatter)?
 
Hi David

Thanks for your response. The chart IS xy-scatter with lines visible, but I
still don't see my x-axis labels. I know I'm doing something wrong, just not
sure what I've missed.

Amanda
 
Hi,

The axis on a scatter plot will be numerical. If you want categorical
axis the use Line chart.
If the data you are plotting is true x and y values and you still need
the categorical style labels then you will need to create your own axis
labels. Have a look at Jon Peltier's arbitary axis examples.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy
 
Thanks for your response. The chart IS xy-scatter with lines visible, but I
still don't see my x-axis labels. I know I'm doing something wrong, just not
sure what I've missed.
Click to expand...

Whoops!

Now that I look again at your labels, I realise that in fact you may
probably want any chart type EXCEPT XY (scatter). XY scatter is looking for
numbers along the X axis, and you've got a letter for some, which is
probably why it's gone the way it has.
 
Back
Top