Yes—columns in an Excel clustered column chart can overlap when the series overlap setting is above 0%, or when series are plotted on different axes. In Excel for Microsoft 365 on Windows, select a column, right-click and choose Format Data Series, then open Series Options and set Series Overlap to 0% to put the series side by side; use a negative value to add space between them. Change Gap Width separately to control the space between category groups.
What overlap means in a clustered column chart
A clustered column chart displays each category as a group of vertical columns, with one column for each data series. For example, if a worksheet has sales for 2024 and 2025 across four regions, each region appears as a group containing two columns. The Series Overlap setting controls how much the columns for series in the same category cover one another.
At 0%, the series columns sit beside each other. A negative setting separates them with a small gap, while a positive setting brings them over one another. At 100%, columns in the same category are drawn in the same position, so the later series can hide the earlier one. The values in the worksheet do not change; this setting changes only the chart’s appearance.
Overlap is not the same thing as the space between categories. If you want to make the groups for North, South, East, and West farther apart, adjust Gap Width. If the columns inside each group are hiding each other, adjust Series Overlap. Knowing which spacing you want to change prevents a common round of trial and error.
How to change Series Overlap in Excel
Use these steps in the Windows desktop version of Excel for Microsoft 365:
- Select the chart, then click one of the columns belonging to the series you want to format. If necessary, click again to select the whole series rather than a single data point.
- Right-click the selected series and choose Format Data Series. The formatting pane opens on the right.
- In the pane, select Series Options—the column-chart icon if the pane shows icons—and find Series Overlap.
- Enter or choose 0% for side-by-side columns. Choose a negative percentage for separation or a positive percentage to make columns overlap.
- To change the distance between category groups, adjust Gap Width in the same Series Options area.
Excel may show the controls as sliders or numeric fields depending on the version and pane size. You can type a value into a field when one is available. The overlap control applies to the chart’s series grouping, so check the whole chart after changing it, especially if some series use a secondary axis.
On Excel for Mac, select or Control-click a series and choose Format Data Series, then look for Series Options in the formatting pane. The labels and pane layout can differ slightly by release. Excel for the web has fewer chart-formatting controls than the desktop apps; if Series Overlap is not available, open the workbook in desktop Excel to change it.
Series Overlap and Gap Width are different settings
These two controls are often confused because both affect how crowded a chart looks. Series Overlap changes the horizontal position of the columns that belong to different series within one category. Gap Width changes the space between category groups and therefore affects the overall density of the chart.
- Columns from different series cover one another: reduce Series Overlap, usually to 0%.
- Columns sit side by side, but are too close together within a group: try a negative Series Overlap.
- The groups are too close together or too far apart: adjust Gap Width.
- There is only one series: Series Overlap will not create a meaningful side-by-side arrangement; Gap Width is the relevant spacing control.
Gap Width is expressed as a percentage related to column width. A smaller percentage generally makes the columns wider and the category groups more crowded; a larger percentage generally makes columns narrower and leaves more space between groups. It is not a direct measurement in pixels, and the result also depends on the chart’s size and number of categories. Make modest adjustments and judge the chart at the size where readers will see it.
Why columns may overlap even when the setting is zero
A 0% overlap value is a useful first check, but it does not resolve every chart that looks layered. One common cause is that one or more series use a secondary axis. Excel can draw series assigned to the primary and secondary axes in separate plot groups; those groups may occupy the same chart area and appear on top of each other rather than as one ordinary cluster.
To investigate, select a suspicious series and open Format Data Series. Check whether it is plotted on the primary or secondary axis. If the series use comparable units, putting them on the same axis may restore the expected clustering. If they have very different scales—for example, revenue and percentage growth—forcing them onto one axis can make one series difficult to read. In that case, a combination chart with a clearly labeled secondary axis may be more honest than trying to make every column sit side by side.
Also check whether the chart type is actually Clustered Column. A series may have been changed to a line, stacked column, or another type as part of a combo chart. Select the chart and use Chart Design > Change Chart Type to review the assigned type for each series. A stacked chart deliberately places values on top of one another, so changing Series Overlap alone will not turn it into a clustered chart.
A concrete example: two years of regional sales
Suppose the chart contains four regions and two series, one for each year. With Series Overlap at 0%, each region should display two separate columns. If the 2025 column is drawn directly over the 2024 column, inspect the overlap setting first. A positive value can cause that effect, and a 100% setting can make one series almost completely conceal the other.
If both columns are visible but the four regional groups look cramped, leave overlap at 0% and increase Gap Width. If the two columns in each region feel too far apart, use a small negative overlap instead. There is no universally best percentage: the right choice depends on how many categories and series are present, the chart’s dimensions, and whether readers need to compare individual values or scan a broad pattern.
Finally, verify the legend and series order. When columns overlap, the series drawn in front can obscure the other series, making a chart look as though data is missing. Changing series order may change which column appears in front, but it does not solve the underlying comparison problem. Confirm that every series is visible and that the legend identifies it correctly.
When overlap is intentional—and when to avoid it
Overlapping columns can be useful when the goal is to compare the shape or relative size of two series and one series is meant to sit in front of another. For example, a transparent foreground series can be used as a visual reference against a wider background series. This is a deliberate design choice, not the usual meaning of a clustered column chart.
For ordinary comparisons, overlap often makes exact values harder to read. The front column can hide the back one, and similar colors can make the chart’s meaning ambiguous. If overlap is intentional, use contrasting fills, consider transparency where the formatting options allow it, and make the legend and labels clear. Do not rely on color alone to communicate which series is in front.
When readers need to compare values precisely, separate columns are usually easier to interpret. If the chart has many series, even non-overlapping columns can become narrow and difficult to distinguish. Consider reducing the number of series, showing fewer categories, or using a different chart rather than trying to solve every readability problem with a spacing adjustment.
Choose a chart type that suits the comparison
A clustered column chart works well when categories are discrete and readers should compare a small number of series within each category. It is particularly useful for showing side-by-side values such as actual versus target or one year versus another. The columns share a baseline, which supports direct comparison.
Other chart types can be clearer for different questions:
- Clustered bar: use horizontal bars when category labels are long or when there are many categories. The same general overlap and gap concepts apply to bars.
- Stacked column: use this when the total and each category’s parts matter. Values accumulate in one column, so it is not intended to show every series side by side.
- Line chart: use this for a continuous sequence such as monthly measurements, especially when the trend over time matters more than separate column heights.
- Small multiple charts: use separate charts with consistent scales when there are too many series to compare legibly in one plot.
A common misconception is that a stacked chart is simply a clustered chart with overlap turned up. They encode the data differently: a clustered chart places series alongside one another, while a stacked chart adds series vertically. Choose based on the comparison readers need to make, not just on which arrangement fits more data in the chart area.
Common troubleshooting checks
If the chart still does not look right after setting overlap to 0%, work through these checks before rebuilding it:
- Confirm that you selected the full data series, not just one column or data point.
- Check that the chart is a clustered column chart and that the affected series have not been assigned different chart types.
- Look for a secondary-axis series that may be drawn over the primary-axis group.
- Check whether there are more series than expected because the chart’s data range includes an extra row or column.
- Adjust Gap Width only after confirming the columns are correctly grouped; it changes spacing, not the chart’s data arrangement.
- Resize the chart or simplify the categories if the columns are too narrow to distinguish at the intended display size.
If the chart is based on a PivotTable, changes to its layout or fields can alter the series and categories. Recheck the chart after changing the PivotTable, since the issue may be the updated data structure rather than a formatting setting. Likewise, adding a new series can make an existing chart feel crowded even though its overlap percentage has not changed.
Frequently Asked Questions
How do I stop columns from overlapping in Excel?
Select a column series, choose Format Data Series, open Series Options, and set Series Overlap to 0%. If the series are on different axes, review their axis assignments too; the overlap control may not arrange them as one cluster.
What is the best Series Overlap percentage?
For a standard clustered column chart, 0% is a sensible starting point because it places series beside each other. A negative value can add separation, while a positive value is appropriate only when you deliberately want the columns to cover one another.
Does Gap Width fix overlapping columns?
Not usually. Gap Width changes the spacing between category groups and the apparent width of the columns. Use Series Overlap to change how series relate to each other inside a category.
Why does one column hide another at 100% overlap?
At 100%, the series columns occupy the same horizontal position. The series drawn in front can cover the one behind it. Set the overlap to 0% for side-by-side columns or choose a chart type that better suits the comparison.
Can Excel for the web change Series Overlap?
Chart-formatting features in Excel for the web can differ from the Windows and Mac desktop apps. If the Series Overlap control is missing, open the workbook in desktop Excel and use Format Data Series > Series Options.
Related
- Company Contact List Template for Excel
- Combine Excel Files into One: Methods and Best Practices
- How to Combine Excel Files: Methods and Common Issues
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart: How to Add, Move, and Customize a LegendTo add a legend in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design…
- Think-Cell Waterfall Chart: How It Works and When to Use ItA think-cell waterfall chart is a PowerPoint chart that shows how a sequence of positive and negative changes…
- Excel Pivot Chart Example: Build a Sales DashboardAn Excel PivotChart example is a chart that summarizes sales by month and region, then lets you rearrange…
- Agile Gantt Chart in Excel: Plan Sprints and ReleasesYes. You can make an Agile Gantt chart in Microsoft Excel by listing work items, adding start and…
- How to Add a Line in an Excel Org ChartTo add a reporting line in an Excel org chart, select the employee’s box and use SmartArt Design…
- Excel Radar Charts Over Time: Setup and Better OptionsYes—Excel can use a radar chart to compare measurements from different dates, but a radar chart does not…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.