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.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
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.