Excel Bar Chart: How to Make Bars Wider

To make bars wider in an Excel bar chart, right-click a bar, choose Format Data Series, then under Series Options reduce Gap Width. A smaller gap makes the bars thicker; you can also widen the chart or show fewer categories if the bars still look narrow.

Quick way to widen bars

These steps apply to Microsoft Excel for Microsoft 365 on Windows. You can change the setting while the chart is selected, and the chart updates as you adjust it:

Click a bar once to select the data series. If you click again, Excel may select an individual data point instead.
Right-click the selected bar and choose Format Data Series. You can also select the series and use Chart Format > Format Selection on the ribbon.
In the Format Data Series pane, select Series Options, shown with a small column-chart icon.
Find Gap Width and enter a smaller percentage. For example, change 150% to 75% to make the bars visibly wider.

Enter a new value in the box or use its arrows, if shown. There is no need to rebuild the chart or change the source data. If the chart has several series, make sure you selected the series whose bars you want to adjust; the setting is available for each series.

What Gap Width means

Gap Width controls the empty space between category groups relative to the width of a data point. In a regular, single-series bar chart, lowering the setting reduces the blank space between successive bars and gives each bar more of the available plot-area space. Raising it makes the bars thinner and the gaps more prominent. A setting of 0% removes the gaps between categories, while a high setting can make bars look like narrow marks.

The percentage is a chart-spacing control, not a measurement in pixels or a promise that a bar will be a particular number of points wide. The visible result depends on the chart’s dimensions, the number of categories, and the series arrangement. As a starting point, try 75% or 50%, then adjust by eye. You do not have to use a particular value; the right setting depends on whether the chart needs compact bars or clearly separated categories.

Gap Width is different from Series Overlap. Gap Width changes spacing between category groups. Series Overlap changes how multiple series in the same category are positioned relative to one another. If bars from different series are side by side, reducing the gap alone may not make their grouping look the way you intend.

Adjusting clustered and stacked bar charts

A clustered bar chart can display several series beside one another for each category. For example, a chart comparing 2024 and 2025 sales across five regions has two bars in each region’s group. Gap Width changes the spacing between region groups. To make the two bars within each region sit closer together or overlap, adjust Series Overlap in the same Series Options pane.

Series Overlap is often set below 100% when you want side-by-side bars to remain distinguishable. A value of 100% places the series directly on top of one another, which can hide a bar unless the series use different fills or transparency. Negative overlap separates the series more. Check the chart after changing it, because the best balance depends on the number of series and how similar their values are.

Stacked bar charts place series segments end to end within each category, so the full bar represents a total. Gap Width affects the space between those category bars; it does not create separation between the stacked segments. If you need visible boundaries inside a stack, use contrasting fills or borders rather than increasing the category gap.

Make bars wider by changing the chart layout

Gap Width cannot overcome every space constraint. If the plot area contains many categories, each category gets only a share of the available height in a horizontal bar chart. Even a low gap percentage may leave the bars looking small when there are dozens of categories. Try these layout changes as well:

Make the chart larger. Drag a corner or side handle outward to give the plot area more room. For a horizontal bar chart, adding chart height is especially useful because it creates more vertical space for the categories.
Show fewer categories. Filter the source table or chart to focus on the most relevant entries. A chart showing ten products can give each bar more room than one showing fifty.
Increase the plot area. If the chart title, legend, or long category labels take up a large share of the chart, reposition or simplify them so the bars have more room.
Use a different chart orientation. A column chart may fit short category labels and a modest number of categories better; a horizontal bar chart often suits long labels.

Resizing the chart changes the physical space available, whereas changing Gap Width changes the spacing within that space. Combining the two is often more effective than pushing Gap Width to an extreme.

Bar charts versus column charts

Excel uses bar chart for bars that extend horizontally and column chart for bars that extend vertically. Both use the same general Gap Width control in the Format Data Series pane. In a bar chart, the categories run down the vertical axis, so bar thickness is measured vertically. In a column chart, categories run along the horizontal axis, so thickness is horizontal.

This distinction helps diagnose a common mismatch: someone may select a horizontal bar chart but try to change the value axis scale, expecting the bars to become thicker. The value axis controls the scale of bar length, not the thickness. To change thickness, adjust Gap Width or change how much plot-area space each category receives. To change length, adjust the value-axis scale or the underlying values.

You can change orientation through Chart Design > Change Chart Type, then choose a bar or column option. Changing chart type can alter how labels and series are laid out, so review the legend, category order, and axis labels afterward.

Why the bars may still look too thin

If lowering Gap Width seems to have little effect, check the chart structure and the amount of data rather than repeatedly changing the same number. Common causes include:

Too many categories: Each category receives limited space. Filter or split the chart into smaller views, or make the chart taller for horizontal bars.
The wrong item is selected: Excel may have selected a chart area, axis, or one data point instead of the whole series. Right-click a bar and confirm that the pane title says Format Data Series.
Several series are clustered: The available category space is divided among the series. Adjust Series Overlap if appropriate, or remove series that do not need to be compared in the same chart.
The plot area is small: A large legend or lengthy labels can squeeze the bars even when the outer chart object looks large. Try moving the legend or reducing label clutter.
The chart is a histogram or another specialized chart: Some chart types have their own bin or spacing controls and may not expose the same data-series options as an ordinary bar chart. Confirm the chart type before following standard bar-chart steps.

Also check whether the bars only appear thin because the chart is viewed at a small zoom level or printed at a reduced size. Judge the chart at the size at which readers will see it. A setting that looks clear on a large monitor may become crowded in a report or on a printed page.

Choosing a useful bar width

Wider is not automatically better. Bars need enough separation for viewers to tell categories apart, particularly when many categories are shown or adjacent bars have similar colors. A small gap can make a compact chart feel solid and easy to scan, but a zero gap may make separate categories look like one continuous block. Start with a moderate reduction, then check that the category boundaries remain obvious.

For a chart comparing a few categories, a gap around 50% to 100% can be a reasonable range to try, not a universal rule. For a crowded chart, widening the whole chart or reducing the number of categories may improve readability more than setting the gap close to zero. In a clustered chart, retain enough room to distinguish both the groups and the individual series. Add data labels only when they help; labels can introduce clutter even though they do not directly set bar thickness.

On Excel for Mac, the same general setting is available through the chart’s data-series formatting controls, though the pane layout and ribbon labels can differ slightly by version. In Excel for the web, chart formatting options may be more limited or arranged differently from desktop Excel. If Gap Width is not available in the web interface, open the workbook in the desktop app and format the series there.

Frequently Asked Questions

What Gap Width should I use in Excel?

There is no single best value. Try reducing the current percentage to 75% or 50%, then check whether the bars are easy to distinguish. Choose a value based on chart size, category count, and whether the chart has one series or several.

Can I set Gap Width to 0%?

Yes. A 0% gap removes the space between category bars, but it can make categories look joined together. Use it only when that appearance suits the chart, and check that viewers can still identify where one category ends and the next begins.

Can I make just one bar wider?

Gap Width is a series-level spacing control, so it is not a direct way to give one category bar a different thickness. Excel lets you format an individual data point’s appearance, but that does not provide a simple independent width setting for that one bar. If one category needs emphasis, consider changing its color or adding a callout.

Does Gap Width change the length of the bars?

No. It changes spacing and apparent thickness, not the value represented by a bar. Bar length depends on the data and value-axis scale. A shorter-looking bar should be investigated by checking its value, axis bounds, and chart type.

Why are my bars still thin at a low Gap Width?

The chart may contain many categories, multiple series, or a small plot area. Make the chart larger, reduce the number of categories, or simplify the legend and labels. For horizontal bars, increasing chart height usually gives each category more vertical room.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.