If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart Axis naming question
When you set up a chart in Excel, you can format the axis' size, decimal
point, etc. Is there anyway that you can add text into the axis title instead of it being just the numerical value? So, for instance, if my line chart has the Y axis with a scale of 1, 2, 3, 4, 5, is there anyway I can format the access to say 1 - Expert, 2 - Advanced, etc??? i know that I can move the chart into Powerpoint and put a text box down the axis, but I was hoping there may be a way do just do that in Excel. Thanks!! |
#2
|
|||
|
|||
Chart Axis naming question
Hi,
Have a look at Jon's page on creating arbitrary axis scale. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Cheers Andy SK wrote: When you set up a chart in Excel, you can format the axis' size, decimal point, etc. Is there anyway that you can add text into the axis title instead of it being just the numerical value? So, for instance, if my line chart has the Y axis with a scale of 1, 2, 3, 4, 5, is there anyway I can format the access to say 1 - Expert, 2 - Advanced, etc??? i know that I can move the chart into Powerpoint and put a text box down the axis, but I was hoping there may be a way do just do that in Excel. Thanks!! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stacked Bar Chart with Secondary Axis | Benjamin B | Charts and Charting | 7 | May 15th, 2005 04:00 AM |
Clustered Column Chart with Second Axis | Jon Peltier | Charts and Charting | 0 | April 10th, 2004 04:56 AM |
force graph to axis of choice | bbxrider | Charts and Charting | 2 | February 12th, 2004 09:51 PM |
Two Y axis with different scales for a line chart | vacaut | Charts and Charting | 3 | October 30th, 2003 01:36 PM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |