View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How to put a NAME in the Horizontal category axis label.

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.