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

[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

 

[David Biddulph]

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?

Change the chart type to XY (scatter)?

 

[Guest]

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

 

[Andy Pope]

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

 

[David Biddulph]

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.

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.