Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Align Clustered Column Chart Category Axis Labels
I have a simple clustered column chart containing one series. Instead of the
category X axis labels being directly aligned under each column, is there a way to align the labels directly under each major tick mark? In other words, I would like the X axis labels to appear under the right side of each column when the gap width is set to zero. Thanks for your help. |
#2
|
|||
|
|||
Stephanie,
You can do so by setting up a dummy X axis. This example explains how to put a colored quadrant together. You will specifically want to use the X axis techniques that are described in the example. http://www.peltiertech.com/Excel/Cha...ackground.html --- Regards, John Mansfield http://www.pdbook.com "Stephanie" wrote: I have a simple clustered column chart containing one series. Instead of the category X axis labels being directly aligned under each column, is there a way to align the labels directly under each major tick mark? In other words, I would like the X axis labels to appear under the right side of each column when the gap width is set to zero. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |