How to adjust the Bar Chart to make bars wider in Excel?
This article is talking about adjusting Bar Chart to make all bars wider in Excel as below screenshot shown.
To make bar wider in a Bar Chart, please do as follows.
1. Click on any bar in the Bar Chart and right click on it, then select Format Data Series from the right-clicking menu. See screenshot:
2. In the popping up Format Data Series pane, move the Zoom bar of the Gap Width to the left side until the bar width meets your needs under the Series Options section. See screenshot.
3. Close the Format Data Series pane.
Then you can see bars in specified Bar Chart becoming wider as below screenshot shown.
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 9 days agoYour articles are life-savers!
To post as a guest, your comment is unpublished.· 9 months agoSorry... this doesn't work on a PC with Office365 2020.10. The control is there but even when set to zero percent for the gap width, the bars are scrawny little narrow bars which will accommodate no text overlay. Something not right.
To post as a guest, your comment is unpublished.· 1 months agosame for my Office 365...