To close the gap between bars in an Excel chart, select a bar, open Format Data Series, and set Gap Width to 0%. This makes the bars in each category sit next to one another. You can use a small value instead of zero if you want a narrow space while keeping the bars visually distinct.
What You’ll Need
- An Excel workbook with a bar or column chart. The instructions below are for Excel for Microsoft 365 on Windows; these chart types use the same Gap Width setting.
- At least one visible data series. If the chart contains several series, you can adjust the spacing between category groups and, separately, how series sit beside one another.
Step-by-Step
- Select the chart. Click once on the chart area so Excel displays the chart-specific tabs on the ribbon. If you select a cell in the worksheet instead, those tabs will not appear.
- Select a bar or column in the series you want to change. Click one bar once. Excel should select the entire series, not just that single data point. Look for selection handles on all the bars that belong to it, or check the selection name in the Chart Format tab’s Current Selection area. If only one bar is selected, click it again carefully or use the selection list to choose the series.
- Open the formatting pane. Right-click a selected bar and choose Format Data Series. On a Mac, Control-click the bar, or use a two-finger click on a trackpad, and choose the same command. You can also use Chart Format > Format Selection after selecting the series. The Format Data Series pane opens, usually at the right of the window.
- Open Series Options. In the pane, select the Series Options icon if the options are shown as icons. It is generally represented by a small column chart. If the pane already displays Series Options, continue to the next step.
- Find Gap Width. Under Series Options, locate the Gap Width control. Depending on the Excel window size, it may appear as a slider, a number box, or both. The value is a percentage that controls the space between category groups relative to the width of a bar.
- Set the gap to zero. Type 0% in the Gap Width box and press Enter. If your version shows a slider without an obvious number box, drag it all the way to the left. The bars should now touch within the chart plot area.
- Choose a small gap instead if needed. If touching bars make the chart hard to read, enter a low value such as 10% or 25%, then adjust it until the bars are close but still visually separate. The exact appearance depends on the chart size, number of categories, and number of series.
- Review the whole chart. Close the formatting pane if it covers the chart, then check the labels, legend, and all category groups. If you have multiple series, confirm that the series are still arranged as intended. Save the workbook after you are satisfied with the result.
You can also change Gap Width by selecting a series and opening Chart Format > Format Selection. This reaches the same Format Data Series pane as the right-click method; it is useful when right-click menus are difficult to use or when the chart is crowded.
Common Mistakes
Changing the chart area instead of the data series: Clicking the background selects the chart area, not the bars. The pane will then show chart-area settings rather than Gap Width. Select a bar itself and reopen Format Data Series.
Changing only one data point: If you select a single bar rather than the series, some formatting changes may apply only to that point. Check that the whole series is selected before changing the setting. If you deliberately want one point to look different, keep it selected; otherwise, select the series again.
Looking for Gap Width in the wrong chart type: Gap Width is a setting for supported bar and column charts, not a general spacing control for every chart. Line, pie, and scatter charts use different formatting options. If you have a histogram, its bin settings control the distribution of values; do not assume that ordinary column-chart spacing is the right control for it.
Confusing Gap Width with Series Overlap: Gap Width changes the space between category groups. Series Overlap controls how multiple series within the same category are positioned relative to one another. If the bars from separate series are separated or overlapping in an unwanted way, changing Gap Width alone may not solve it.
Expecting zero to add a border: At 0%, adjoining bars can appear to merge, especially when neighboring bars have the same fill color. A zero gap does not add outlines or separators. Use a small nonzero gap or add borders if the categories need to remain visually distinct.
Tips
Make a small adjustment first when the chart is presentation-ready. A chart with no gaps can look compact, but it may also look like a continuous block of color. Try 10% or 25% before settling on zero, then inspect the chart at the size at which people will actually view it.
Use consistent spacing across comparable charts. If you have several charts that readers will compare, use the same Gap Width where practical. Otherwise, identical values can look more or less important simply because the bars occupy different amounts of horizontal space.
Choose colors and borders with the spacing in mind. When bars touch, contrasting series colors or thin outlines can help people distinguish categories. To format outlines, select the series and use the pane’s Fill & Line options. Check that the result remains clear when printed in grayscale or viewed on a smaller screen.
Give the chart enough room. The setting controls spacing, but it cannot create more space for category labels. If labels overlap after widening the bars, enlarge the chart, shorten the labels, or adjust the axis label presentation rather than adding gaps back without checking the full layout.
Keep a copy of the original chart if the change is substantial. You can duplicate a chart before experimenting, especially if it has several series or carefully tuned formatting. That gives you a quick visual comparison and a fallback if you prefer the original spacing.
Troubleshooting
Gap Width is missing from the pane. First make sure you selected an individual bar or column in a supported chart, rather than the chart background, legend, or axis. Then look for Series Options in Format Data Series. If the chart is a line, pie, scatter, or another unsupported type, change it to a bar or column chart using Chart Design > Change Chart Type if that suits the data. The available options depend on the chart type.
The bars do not appear to change. Confirm that the number in Gap Width changed and that you pressed Enter after typing it. Also check that you have not selected a different series from the one you are viewing. If the chart has only a few categories, or the plot area is wide, a small adjustment may be subtle; try 0% temporarily to make the effect obvious, then choose the preferred value.
Bars touch, but categories seem to run together. Set Gap Width to a small positive value, such as 10% or 20%. You can also use contrasting fills or subtle borders. If the bars are from different series within one category, inspect Series Overlap in the same Series Options area. Adjusting overlap changes the relationship between those series; it does not replace the category spacing control.
The setting affects the wrong bars. Reopen the pane and check the selected series name. For a chart with multiple series, repeat the selection and formatting process for each series if the appearance is not consistent. Some chart layouts may show series-specific choices, so verify the result for every category rather than assuming a change applied everywhere.
The steps look different in Excel for the web. Select the chart and try right-clicking a bar to find Format Data Series. The browser version’s chart-formatting controls can differ from the desktop app, and some options may not be available in a given interface. If Gap Width is not offered, choose Open in Desktop App and make the change in Excel for Microsoft 365 on Windows or Mac.
The chart changed after switching chart type. Changing from a column chart to a line or other chart can remove the Gap Width control because that chart type does not use it. Return to a bar or column chart if adjacent rectangular bars are essential, then set the spacing again and review the axis labels and legend.
Frequently Asked Questions
What Gap Width value makes bars touch?
Set Gap Width to 0%. This removes the space between adjacent category groups in a supported bar or column chart. It does not automatically add borders between bars.
Can I make the gap smaller without removing it completely?
Yes. Enter a small positive percentage, such as 10% or 25%, and adjust it to suit the chart. Smaller values generally produce wider bars and less space between categories.
Does Gap Width change the space between multiple series?
It mainly controls spacing between category groups. For the placement or overlap of several series within a category, use Series Overlap in Series Options when that control is available.
Can I close gaps in a horizontal bar chart as well as a column chart?
Yes. Both are bar-chart types, and the same Format Data Series > Series Options > Gap Width setting is used. The chart’s orientation changes how the bars are drawn, not the purpose of the setting.
Why do my bars look joined even when Gap Width is above zero?
A small gap can be hard to see when the chart is large, the bars are wide, or the display is scaled down. Increase Gap Width slightly, add subtle borders, or enlarge the chart to make separation clearer.
Will changing Gap Width change my worksheet data?
No. It changes the chart’s appearance, not the values in the worksheet. You can adjust it again at any time by selecting the series and changing the Gap Width setting.
Related
- Capitalize All Letters in Google Sheets with UPPER
- Capitalize All Names in Excel with PROPER and Fill Down
- Calculate the Number of Months in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Chart: Group Dates by Month?Yes. In Excel for Microsoft 365 on Windows, group dates in the PivotTable behind the PivotChart: right-click a…
- Excel Waterfall Chart: Can Colors Follow Values?Excel’s built-in waterfall chart can color increases, decreases, and totals differently, but it does not automatically apply colors…
- Is an Excel Dashboard Free? Templates, Costs, and OptionsYes, you can make an Excel dashboard without paying extra for a dashboard tool: the dashboard is a…
- Edit a Gantt Chart in Excel: Dates, Tasks, and BarsYes. To edit a Gantt chart in Excel, change the task names, start dates, finish dates, or durations…
- Excel Trendline Equation: How to Get It From Data in ExcelTo get an Excel trendline equation from data, make a chart, select its data series, and add a…
- How to Calculate an Average in an Excel Pivot TableTo calculate an average in an Excel PivotTable, add the numeric field you want to average to the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.