A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

X-Axis Labels



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2010, 04:39 PM posted to microsoft.public.excel.charting
Martin Baker
external usenet poster
 
Posts: 1
Default X-Axis Labels

I had this problem years ago, but do not remember what the answer was, or if
there even was an answer. I fear I am missing something obvious - if so,
please indulge the question that follows and I beg your forgiveness in
advance:

I am trying to apply X-Axis Labels to a simple bar chart (5 points). I wish
the five lables to be applied either above or one their respective bars.
When I enter the data range (e.g.: =Statistics!$B$6:$B$11) to the field
"Category (x) Axis Labels:" only the first (in the example, $B$6) is applied
- to all five bar-points. If I attempt to enter a manual range (e.g. "one",
"two", "three", etc.) in the field, again, only the first label is applied to
all five bar-points.

I have tried pretty much ever variation of chart option and label option I
could think of, to no avail. Thank you in advance for any help the Community
might offer.
--
Martin Baker
Data Protection Specialist
  #2  
Old April 25th, 2010, 03:18 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default X-Axis Labels

Excel is apparently applying the series name to the data points.

Excel 2003 & earlier: double click the series to open the Format Series
dialog, click on Data labels tab, choose Categories option.

Excel 2007 & later: select series, go to Chart Tools Layout tab, click
down arrow on Data Labels button, choose More Data Label Options, and on
Label Options, choose Category Name.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/24/2010 11:39 AM, Martin Baker wrote:
I had this problem years ago, but do not remember what the answer was, or if
there even was an answer. I fear I am missing something obvious - if so,
please indulge the question that follows and I beg your forgiveness in
advance:

I am trying to apply X-Axis Labels to a simple bar chart (5 points). I wish
the five lables to be applied either above or one their respective bars.
When I enter the data range (e.g.: =Statistics!$B$6:$B$11) to the field
"Category (x) Axis Labels:" only the first (in the example, $B$6) is applied
- to all five bar-points. If I attempt to enter a manual range (e.g. "one",
"two", "three", etc.) in the field, again, only the first label is applied to
all five bar-points.

I have tried pretty much ever variation of chart option and label option I
could think of, to no avail. Thank you in advance for any help the Community
might offer.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.