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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|