Category (X) Axis Labels not found in Excel 2003

Hi,

I am drawing an X-Y Line graph. The X axis values run from 0 to 12. Right
now, the X axis has numbers in it. I want to change the numbers to say text
like: 0, Week 2, Week 6, Week 8 and Week 12.

Per the instructions on the website
http://www.wfu.edu/~massd2/Chart_options.htm I was trying to add labels to
say 0, Week 2, Week 6 etc., and point the Category (X) axis labels section to
this. however, I do not see "Category (X) axis labels" section under the
"Series" Tab. I verified that Analysis Pack Add-in is installed on my
computer.

Am I missing something? How can I force x axis to read Text labels instead
of the numbers. Please help. Thanks

Is it an XY chart or a Line chart? If the numbers match what you want the
labels to say (0, 2, 4, 6 values for Week 0, Week 2, Week 4, and Week 6),
don't mess around. Use a custom number format for the X axis. Double click
the axis, click on the Number tab, select Custom in the list, and enter
"Week "0 in the box. That's right, the double quotes are the first and the
next-to-last characters in the format string.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vrk1" <vrk1@discussions.microsoft.com> wrote in message
news:0CC6A51D-FCFE-425F-AE16-6B86C9C0E382@microsoft.com...
> Hi,
>
> I am drawing an X-Y Line graph. The X axis values run from 0 to 12.
> Right
> now, the X axis has numbers in it. I want to change the numbers to say
> text
> like: 0, Week 2, Week 6, Week 8 and Week 12.
>
> Per the instructions on the website
> http://www.wfu.edu/~massd2/Chart_options.htm I was trying to add labels to
> say 0, Week 2, Week 6 etc., and point the Category (X) axis labels section
> to
> this. however, I do not see "Category (X) axis labels" section under the
> "Series" Tab. I verified that Analysis Pack Add-in is installed on my
> computer.
>
> Am I missing something? How can I force x axis to read Text labels
> instead
> of the numbers. Please help. Thanks

Thanks! Thats exactly what I wanted.


"Jon Peltier" wrote:

> Is it an XY chart or a Line chart? If the numbers match what you want the
> labels to say (0, 2, 4, 6 values for Week 0, Week 2, Week 4, and Week 6),
> don't mess around. Use a custom number format for the X axis. Double click
> the axis, click on the Number tab, select Custom in the list, and enter
> "Week "0 in the box. That's right, the double quotes are the first and the
> next-to-last characters in the format string.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "vrk1" <vrk1@discussions.microsoft.com> wrote in message
> news:0CC6A51D-FCFE-425F-AE16-6B86C9C0E382@microsoft.com...
> > Hi,
> >
> > I am drawing an X-Y Line graph. The X axis values run from 0 to 12.
> > Right
> > now, the X axis has numbers in it. I want to change the numbers to say
> > text
> > like: 0, Week 2, Week 6, Week 8 and Week 12.
> >
> > Per the instructions on the website
> > http://www.wfu.edu/~massd2/Chart_options.htm I was trying to add labels to
> > say 0, Week 2, Week 6 etc., and point the Category (X) axis labels section
> > to
> > this. however, I do not see "Category (X) axis labels" section under the
> > "Series" Tab. I verified that Analysis Pack Add-in is installed on my
> > computer.
> >
> > Am I missing something? How can I force x axis to read Text labels
> > instead
> > of the numbers. Please help. Thanks
>
>
>