Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Category (X) Axis Labels not found in Excel 2003
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Category (X) Axis Labels not found in Excel 2003
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Category Axis Date Labels | Charts and Charting in Excel | |||
Appearance two labels on category axis | Charts and Charting in Excel | |||
Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
alignment of y axis category labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel |