Excel Chart Bar Width Too Thin (2 Quick Solutions)

If your Excel chart bar width is too thin, and you are looking for a solution then this article will be helpful for you. Here, we will walk you through 2 easy and simple methods to solve the problem smoothly.

Excel Chart Bar Width Too Thin: 2 Simple Solutions

The following table has the Date and Sales columns. We will use these columns to insert a Column Chart. Since the Date column has the date in it, the bar width of the chart will be too thin.

Let us first show you the chart bar width too thin.

Steps:

• First, we will select the entire data table.
• Further, we will go to the Insert tab.
• Next, from Insert Column or Bar Chart group >> we will select 2D Clustered Column chart.

Finally, you can see a Column chart bar width too thin.

Therefore, we want to solve the problem and make the chart bar width thick enough. To do so, we will follow 2 methods. Here, we used Excel 365. You can use any available Excel version.

1. Use of Format Axis Option

In this method, we will use the Format Axis option to solve the problem of the Excel chart bar width too thin.

Solution:

• In the beginning, we will right-click on the X–axis of the chart.
• Here, as the Date is on the X-axis, we will right-click on the X-axis.
• Afterward, we will select the Format Axis option from the Context Menu.

A Format Axis dialog box will appear on the left side of the Excel sheet.

• Next, from Axis Options >> select Text axis.

Therefore, you can see the chart bar width has become thick.

Hence, the problem of the Excel chart bar width being too thin is solved.

Later, we will format the chart to make it more presentable.

• After that, we will click on the chart.
• Moreover, we will go to the Chart Design tab.
• Then, from the Chart Styles group, we selected a Chart Style according to our preference.

As a result, you can see the chart with a thick chart bar width.

Read More: How to Make a Simple Bar Graph in Excel

2. Using Format Data Series Option

The following table has Month and Sales columns. We will use this table to insert a Bar chart. As the table contains more data entries or more numbers of rows, the chart bar width will be too thin. In this method, we will use the Format Data Series option to solve the problem of the Excel chart bar width too thin.

Steps:

• First of all, we will select the entire data table.
• After that, we will go to the Insert tab.
• Next, from Insert Column or Bar Chart group >> we will select a 2D Clustered Bar chart.

Here, you can see the chart bar width is too thin.

Solution:

Next, we will solve the problem.

• Afterward, we will right-click on the bar of the chart.
• Moreover, we will select the Format Data Series option from the Context Menu.

After that, a Format Data Series dialog box will appear on the left side of the Excel sheet.

• Next, from Series Options, we will set the Gap Width to 30%.

Here, you must decrease and set the Gap Width according to your preference and adjust the bar width of the chart.

As a result, we can see the bar width has become thick.

Therefore, the problem of the Excel chart bar width being too thin has been solved.

Next, we will format the chart to make it more presentable.

• After that, we will click on the chart.
• Afterward, we will go to the Chart Design tab.
• Then, from the Chart Styles group, we selected a Chart Style according to our preference.

Hence, you can see the chart with a thick bar width.

Read More: How to Create a Bar Chart in Excel with Multiple Bars

Download Practice Workbook

Conclusion

Here, we tried to show you 2 methods to solve the problem when the Excel chart bar width is too thin. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below.

Related Articles

• How to Make a Bar Graph in Excel without Numbers
• How to Make a Diverging Stacked Bar Chart in Excel
• How to Make a 100 Percent Stacked Bar Chart in Excel
• How to Create Clustered Stacked Bar Chart in Excel
• How to Make a Grouped Bar Chart in Excel
• How to Make a Double Bar Graph in Excel

<< Go Back to Excel Bar Chart | Excel Charts | Learn Excel