Category (X) Axis Labels not found in Excel 2003

[vrk1]

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

 

[Jon Peltier]

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

 

[vrk1]

Thanks! Thats exactly what I wanted.

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
_______