The usual way to change the width of the vertical bars in a Column chart type is to change the gap width (in all versions of Excel, Windows and Mac).
Select the data series by clicking on one of the bars (just to be sure the data series is selected).
Right-click or control-click, and choose Format Data Series from the context menu.
In the Format Data Series dialog box, select Options.
Then change the Gap width.
For wider bars, make the gap width smaller.
For narrower bars, make the gap width larger.
- Mike Middleton, www.TreePlan.com
Forum Discussion
Solved
Resizing Bar Width in Clustered Column Chart
I'm building a clustered column chart (photo below), and would like to resize the width of the bars in that chart if possible, but I am not having any luck finding a way to do this. I know that othe...
TarcMaylor,
There is no method that could be used to change width of column unless we resize the whole chart to make the column wider. There is also an idea about adjusting blank space, you can vote it up.
Regards,
TarcMaylor,
There is no method that could be used to change width of column unless we resize the whole chart to make the column wider. There is also an idea about adjusting blank space, you can vote it up.
Regards,
"No Method to change the width of the bar chart" This is NOT a solution.
I too am in the same situation - would like to increase the width of the bar charts since there is so much white space.
Jose
A:
The usual way to change the width of the vertical bars in a Column chart type is to change the gap width (in all versions of Excel, Windows and Mac).
Select the data series by clicking on one of the bars (just to be sure the data series is selected).
Right-click or control-click, and choose Format Data Series from the context menu.
In the Format Data Series dialog box, select Options.
Then change the Gap width.
For wider bars, make the gap width smaller.
For narrower bars, make the gap width larger.
- Mike Middleton, www.TreePlan.com