Category (X) Axis Labels not found in Excel 2003

  • Thread starter Thread starter vrk1
  • Start date Start date
V

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
 
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
 
Thanks! Thats exactly what I wanted.


Jon Peltier said:
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
_______
Click to expand...
 
Back
Top