How to put a NAME in the Horizontal category axis label.

  • Thread starter Thread starter Feejo
  • Start date Start date
F

Feejo

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.
 
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
 
Back
Top