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

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" <Birmangirl@discussions.microsoft.com> wrote in message
news:DADBA0DC-E5E0-44D7-B900-A806DC3636F8@microsoft.com...
> 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" <Birmangirl@discussions.microsoft.com> wrote in message
> news:DADBA0DC-E5E0-44D7-B900-A806DC3636F8@microsoft.com...
> > 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" <Birmangirl@discussions.microsoft.com> wrote in message
>>news:DADBA0DC-E5E0-44D7-B900-A806DC3636F8@microsoft.com...
>>
>>>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" <Birmangirl@discussions.microsoft.com> wrote in message
news:545F6C42-DE49-4986-B058-AA200F80A553@microsoft.com...
> "David Biddulph" wrote:
>
> > "Birmangirl" <Birmangirl@discussions.microsoft.com> wrote in message
> > news:DADBA0DC-E5E0-44D7-B900-A806DC3636F8@microsoft.com...
> > > 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