Chart & Visualization Issues

How to Fix Excel Column Series Overlap on a Secondary Axis

Nimra Malik Oct 10, 2026 869 views

Question details

The user wants to prevent clustered column series from overlapping when one data series is placed on a secondary axis.

How to Fix Excel Column Series Overlap on a Secondary Axis

Product: Excel
Device & OS: not provided
Scenario: Creating a clustered column chart with data series that require different scales, necessitating a secondary axis.
Observed behavior: The columns for different time periods overlap each other instead of appearing side-by-side because the primary and secondary chart groups use separate plotting areas.

Before you start

Before modifying your chart, ensure your data is properly organized in columns and evaluate whether a secondary axis is strictly necessary, as combining columns with a line chart often provides better readability for mixed scales.

Solution 1Recommended

Change One Series to a Line Chart (Recommended)

The most effective way to display two data series with significantly different scales without overlap is to use a Combination Chart, keeping one series as a column and the other as a line.

Because primary and secondary axes create overlapping plotting layers, side-by-side columns are difficult to achieve natively across dual axes. Converting the secondary axis series to a line chart prevents the visual overlap entirely while maintaining both data scales clearly.

Access the Chart Type settings

Right-click the overlapping column series in your existing chart and select Change Series Chart Type from the context menu.

Select Combination Chart

In the Change Chart Type dialog box, navigate to the Combo chart category on the left panel.

Configure Chart Types for Each Series

Set your primary data series to 'Clustered Column'. For your secondary data series, select 'Line' from the dropdown menu and check the 'Secondary Axis' box next to it.

Apply Changes

Click OK to apply the changes. Your chart will now clearly display the column data alongside the line data without any overlapping.

Change One Series to a Line Chart (Recommended)

Best Practice: Using a column-line combo chart is the standard industry practice for displaying primary and secondary axis data, as it is much easier for the audience to interpret.

Solution 2

Move Both Series to the Primary Axis

If the numerical scales of your data series are relatively similar, placing both series on the same axis will automatically group the clustered columns side-by-side.

Solution 3

Use Dummy Series to Force Side-by-Side Columns

If you absolutely need clustered columns for both axes, you can insert blank dummy series into your dataset to offset the columns and simulate a side-by-side layout.

Create Professional Combo Charts in WPS Office

WPS Spreadsheet provides intuitive charting tools that make it incredibly easy to configure primary and secondary axes, adjust series overlaps, and design complex combination charts without frustrating formatting struggles.

1. Open Data in WPS Spreadsheet: Launch WPS Office and open your dataset containing the values you want to chart.
2. Insert a Combo Chart: Highlight your data range, navigate to the Insert tab on the top ribbon, and click on the Chart icon. Select the 'Combo' option.
3. Assign the Secondary Axis: In the chart configuration menu, simply check the 'Secondary Axis' box for the data series that requires a different scale.
4. Adjust the Chart Type: Set the primary series to Clustered Column and the secondary series to Line to perfectly prevent column overlaps, then click Insert.

Seamlessly compatible with Microsoft Excel chart formats (.xlsx)Intuitive Format Data Series pane for quick axis managementEasily switch chart types and handle secondary axes with a single click100% free and lightweight alternative to heavy spreadsheet programs

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel columns overlap when I add a secondary axis?

This happens because Excel treats the primary and secondary axes as entirely separate, transparent plotting layers. Rather than placing the columns side-by-side as it does on a single axis, it draws the secondary axis chart directly on top of the primary axis chart, causing them to overlap.

Can I adjust gap width to fix the overlap on a secondary axis?

Adjusting gap width and series overlap settings alone usually won't create side-by-side columns across different axes because the axes don't share the same alignment grid. You need to use a dummy series workaround or, more ideally, change one series to a line chart.

How do I separate overlapping bars on the same axis in Excel?

If both column series are on the same axis but still overlapping, right-click the bars, select Format Data Series, and look for the 'Series Overlap' slider. Adjust it to 0% or a negative percentage to separate the bars side-by-side.

Excel & Data Problems