Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default How to put a NAME in the Horizontal category axis label.

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   Report Post  
Posted to microsoft.public.excel.misc
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Horizontal category axis all packed together. Feejo Excel Discussion (Misc queries) 3 January 7th 08 10:26 PM
Missing text in category axis label RoxSn Charts and Charting in Excel 1 May 16th 06 08:52 PM
Category axis label problem at column chart Marko Pinteric Charts and Charting in Excel 9 April 24th 06 02:40 PM
label the category axis from 0 to 30, step 5 in an excel chart johnny hanlon Charts and Charting in Excel 2 January 29th 06 12:12 AM
The dates on the category (X) axis label do not match data? TKGerdie Charts and Charting in Excel 1 July 18th 05 07:05 PM


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"