Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How to put a NAME in the Horizontal category axis label. I have one called
temp, so in the Horizontal category axis label I write Temps, the result: on my axis I see the word TEMPS. and not the values of that name range. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I assume you mean the axis title. When you create a title it must contain
just text. Select the unlinked title, then type a link with the qualified name in the formula bar and press Enter, for example: =Sheet1!Temps Simply typing =Temps will not work, because the chart doesn't know what Temps mean. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... How to put a NAME in the Horizontal category axis label. I have one called temp, so in the Horizontal category axis label I write Temps, the result: on my axis I see the word TEMPS. and not the values of that name range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Horizontal category axis all packed together. | Excel Discussion (Misc queries) | |||
Missing text in category axis label | Charts and Charting in Excel | |||
Category axis label problem at column chart | Charts and Charting in Excel | |||
label the category axis from 0 to 30, step 5 in an excel chart | Charts and Charting in Excel | |||
The dates on the category (X) axis label do not match data? | Charts and Charting in Excel |