View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph
 
Posts: n/a
Default XL2003 - Changing X-axis labels in XY Scatter...

"Birmangirl" wrote in message
...
"David Biddulph" wrote:

"Birmangirl" wrote in message
...
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)?


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.
--
David Biddulph