Excel Bar Chart: How to Make Bars Closer Together

To make bars closer together in an Excel chart, select a bar, open Format Data Series, and reduce Gap Width. A smaller gap-width percentage makes the bars wider and reduces the space between category groups; for multiple series, adjust Series Overlap as well if you want the bars within each group closer together.

What the gap-width setting changes

Gap Width controls the empty space between categories in a bar or column chart. For example, in a chart showing one bar for each month, each month is a category. Reducing the gap makes those bars look wider and the groups of bars look more tightly packed. It does not change the values in the worksheet, the chart’s scale, or the number of categories.

The setting is expressed as a percentage, not as a fixed number of pixels. Excel measures the gap in relation to the width of a data marker, meaning a bar or column. A lower percentage produces less space relative to the bars; a higher percentage produces more. The default is commonly 150%, but the precise appearance depends on the chart’s size, number of categories, and series.

Gap Width is therefore the right control when the chart has too much whitespace between category groups. If your chart contains several series and the bars inside each group are separated, that is a different spacing issue: Series Overlap controls how much the series bars overlap within a category.

Change Gap Width in Excel for Microsoft 365

These instructions apply to Excel for Microsoft 365 on Windows. You can change the setting without editing the source data:

Click the chart, then click one of the bars once. This selects the entire data series, rather than just one individual bar.
Right-click the selected bar and choose Format Data Series. The formatting pane opens on the right.
In the pane, select Series Options, represented by a chart-shaped icon if the pane shows icons.
Find Gap Width and enter a smaller percentage, or drag its slider toward the left.
Click outside the pane to review the chart. Adjust the percentage again if the bars look too wide or still too far apart.

For a first adjustment, try changing 150% to 75% or 50%. Those are starting points, not rules: a chart with a few categories may need a different value from one with dozens. You can type a value directly into the setting, so you do not have to rely on the slider.

If you accidentally select just one bar, the pane may show formatting options for a single data point rather than the whole series. Click an empty area of the chart and then click a bar once to select its series. In some versions, clicking a bar again selects only that point; avoid the second click when you intend to format every bar in the series.

Choose a gap width that fits the chart

There is no universally best gap width. The right amount depends on the number of categories, the physical width of the chart, and whether readers need to compare individual bars or see a continuous-looking pattern. A compact chart with eight categories can usually use wider bars than a narrow chart with forty categories, even if both use the same percentage.

Use the chart at the size readers will actually see it. A chart that looks clear while enlarged in Excel may become crowded when pasted into a report or displayed on a small screen. After reducing the gap, check that the bars do not dominate the plot area and that labels remain readable. If category names are long, tightening the bars will not solve label collisions; rotate, shorten, or otherwise simplify the labels instead.

Useful starting points include:

About 150%: A roomier appearance, often useful when you want clear separation between categories.
About 75% to 100%: A moderate reduction that makes bars more substantial without making neighboring categories touch.
About 25% to 50%: A compact look for a chart with many categories, provided the bars and labels remain distinct.
0%: The minimum gap setting. It can make adjacent category bars meet or appear nearly continuous, which may make category boundaries harder to see.

These values are visual choices, not data settings. Compare a couple of options at the final chart size and choose the one that makes both comparisons and category boundaries easy to follow.

When the chart has more than one series

Suppose each category has a bar for two years, or one bar for each of several products. Excel places the series side by side within each category group in a clustered bar or column chart. Reducing Gap Width brings the category groups closer, but may not remove the space between series bars inside a group.

To adjust that internal spacing, select a series and look for Series Overlap in the same Series Options area. A larger overlap value moves the series closer together; at 100%, series in a cluster can occupy the same position and cover one another. A negative overlap spreads them farther apart. For straightforward side-by-side comparison, keep overlap low enough that each series remains visible. If you increase overlap, check that one bar is not hiding another.

For example, with three series in each monthly group, a modestly lower Gap Width can tighten the space between months, while a modestly higher Series Overlap can reduce the gaps among the three bars in each month. Change one setting at a time so you can see which adjustment solves the problem. If the purpose is to compare totals rather than individual series, a stacked bar chart may be more appropriate than forcing a clustered chart to overlap.

Overlap applies to charts with multiple series. If there is only one series, there is no second series to move closer, so Gap Width is the setting to adjust.

Check the chart type and data layout

In Excel, a bar chart normally displays horizontal bars, while a column chart displays vertical bars. Both can have a Gap Width setting, and the basic adjustment is the same. People often use “bar chart” informally for either orientation, so check the chart before looking for the setting.

For a clustered chart, categories form groups along the category axis and series appear within each group. For a stacked chart, series segments are drawn on top of one another within each category. Gap Width can still alter the space between category bars, but Series Overlap is mainly relevant to series arranged side by side; it is not a substitute for changing a stacked chart into a clustered one.

If the chart has many categories, verify that the source data is arranged as intended. Unexpectedly many bars can result when rows and columns are interpreted in the wrong direction. Select the chart and use Chart Design > Switch Row/Column to change how Excel groups the data. This changes which values are categories and which are series; it does not merely change the gap.

Common problems and practical fixes

The setting appears to do nothing: Confirm that you selected a bar series and opened Format Data Series, not Format Chart Area. Then check that the chart is a supported bar or column chart rather than a different chart type.
Only one bar changes: You likely selected a single data point. Re-select the series by clicking a bar once, then reopen the series formatting pane.
Bars within a group remain far apart: Adjust Series Overlap as well as Gap Width when the chart contains multiple clustered series.
Bars look too wide or category groups run together: Increase Gap Width. A lower setting is not automatically better; the categories still need to be visually distinguishable.
Labels overlap after tightening the chart: Widen the chart, reduce the number of displayed categories, or make the category labels shorter. A spacing adjustment cannot create room for text that does not fit.
The bars are hard to compare after overlap changes: Restore a lower overlap or use a stacked chart only if comparing totals and segment contributions suits the data.

Also distinguish bar spacing from chart size. Making the chart wider can create more room for bars and labels, but it does not change the Gap Width percentage. Conversely, changing Gap Width changes the bars’ relative spacing inside the existing plot area without enlarging the chart object.

Excel on Mac and Excel for the web

In Excel for Mac, select the data series and open Format Data Series from its context menu, then adjust Gap Width in Series Options. The pane’s appearance and the placement of controls can differ slightly from Windows, but the setting serves the same purpose. If you are using a Mac trackpad, use the context-menu gesture configured for your device to open the formatting command.

Excel for the web may offer a more limited set of chart-formatting controls than the desktop app, and the available options can vary as the web version changes. If you cannot find Gap Width in the chart formatting pane, open the workbook in the desktop version of Excel and make the adjustment there. The chart formatting is stored with the workbook, so the change can then appear when you view the file online.

Frequently Asked Questions

How do I make bars closer together in Excel?
Click a bar, right-click, choose Format Data Series, and lower Gap Width under Series Options. For multiple clustered series, adjust Series Overlap too if the bars inside each category group need to move closer.

What Gap Width should I use in Excel?
There is no single correct value. Try 75% or 100% as a moderate adjustment, then compare the result at the chart’s final display size. Use more space if categories run together, and less if the bars look too thin.

Can I make only one gap smaller?
Gap Width generally formats the spacing across a data series, rather than one chosen gap between two categories. To emphasize a particular category, consider changing the chart design or source layout rather than expecting the series-wide setting to target one gap.

Why does changing Gap Width not bring my grouped bars closer?
Gap Width affects the spaces between category groups. In a chart with multiple series, the spaces among bars inside each group are controlled separately by Series Overlap. Adjust the setting that matches the space you want to change.

Does reducing Gap Width change the chart data?
No. It changes the visual spacing and width of the bars, not the worksheet values, category order, or axis scale. It is a formatting adjustment only.

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.