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" 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)?
--
David Biddulph

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

"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)?
--
David Biddulph

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

Birmangirl wrote:
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

"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)?
--
David Biddulph




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

"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