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.