Excel Column Chart: Two Axes Without Overlap

Charts & pivot tables · Updated November 19, 2026

Yes—Excel can plot column data on two vertical axes, but the columns will commonly overlap because each axis group positions its columns at the same category. For a readable chart, use columns for the main measure and a line on the secondary axis for the differently scaled measure; if both measures must be columns, use a different layout or chart design rather than relying on the axes to create side-by-side bars.

Why columns overlap on two axes

A secondary vertical axis gives a data series its own numerical scale, usually shown on the right side of the chart. It does not create a second set of category positions. For example, both series for January are plotted at January’s category position. When one column series belongs to the primary axis and another belongs to the secondary axis, Excel may draw them on top of one another instead of placing them in a shared cluster.

This is a chart-layout issue, not necessarily a problem with the data. Columns on one axis can be clustered because Excel knows they share a scale and can arrange them as neighboring series. With separate axis groups, Excel treats the groups independently. As a result, a taller column can hide some or all of the shorter one, and the chart may give a misleading impression of which measure is larger.

Two axes are useful when the measures have different units or very different ranges, such as monthly sales and a percentage rate. They do not make the measures directly comparable: a column’s visual height depends on the scale assigned to its axis. Readers need to check the left and right axis labels to interpret it correctly.

Make the secondary-axis series a line

The clearest common solution is a combination chart: keep the main measure as columns on the primary axis and display the second measure as a line on the secondary axis. The line can share the same month or category positions without covering the columns. This is often a good choice when comparing volume with a rate, target, temperature, or another measure that has a different scale.

  1. Select the chart, or select the data range if you are starting from scratch.
  2. On the ribbon, choose Insert > Insert Combo Chart and select Create Custom Combo Chart. If the chart already exists, use Chart Design > Change Chart Type > Combo.
  3. In the combo settings, choose Clustered Column for the main series and Line for the other series.
  4. Check Secondary Axis for the line series, then choose OK.

For instance, a chart could show monthly orders as columns and the order conversion rate as a line. The columns communicate the number of orders; the line shows how the percentage changes. Add clear axis titles, such as Orders and Conversion rate, so readers know which scale applies to each mark. On Windows, use Chart Design > Add Chart Element > Axis Titles to add titles. Excel for Mac has comparable chart-design controls, though ribbon arrangement and wording can vary by release.

When two column series are necessary

Sometimes the requirement really is two sets of columns, perhaps because a report needs to show two kinds of counts. If the values can be compared meaningfully, the simplest option is to put both series on the same axis and use a clustered column chart. Select the chart, then choose Chart Design > Change Chart Type > Column > Clustered Column. With both series in the same axis group, Excel can place their columns side by side at each category.

That approach is appropriate only when a shared scale makes sense. Do not put values with incompatible units on one axis just to make the bars separate. A count of orders and a percentage, for example, are not interchangeable quantities. If the numbers have different units or ranges, consider a line for one measure, two aligned charts with separate scales, or an indexed comparison. An indexed chart converts each series to a relative measure, such as a percentage of its own starting value, and should be labeled clearly because it no longer displays the original values.

Another option is to make two small charts with the same category order and align them vertically or horizontally. This preserves each measure’s own scale while avoiding bars that conceal one another. It can be more honest and easier to read than forcing unrelated units into one plot area.

What Series Overlap and Gap Width can change

Excel includes column spacing controls, but they do not solve every secondary-axis collision. Select a column, right-click it, and choose Format Data Series. Under Series Options, adjust Series Overlap or Gap Width. Series Overlap controls how much columns in a chart group overlap; Gap Width controls the space between category groups. These controls are useful for improving a normal clustered or stacked column chart’s appearance.

When series are assigned to different vertical axes, changing Series Overlap may not produce a genuine side-by-side cluster across those axis groups. The secondary-axis series can still occupy the same category position as the primary-axis series. If the result remains obscured, switch one series to a line or use separate charts. Increasing Gap Width only makes the columns narrower; it does not create a second category slot or fix the underlying scale relationship.

After changing a chart type, check that the data series are still assigned to the intended axes. A mistaken axis assignment can make a chart look dramatically different even if the underlying values have not changed. Use the legend and axis titles to confirm which series each mark represents.

Check the axis scales and labels

Secondary axes can make modest changes look dramatic if their bounds are much tighter than the primary axis. For example, a rate that varies from 3.0% to 3.5% may appear to swing sharply if its axis starts at 2.9%, even though the actual change is half a percentage point. Conversely, a broad scale can make meaningful movement look nearly flat. Set bounds only when the choice is defensible, and make the scale visible rather than hiding the axis.

To format an axis in Excel for Microsoft 365 on Windows, right-click its labels and select Format Axis. In the pane, review the minimum and maximum bounds, units, number format, and axis title. For a percentage series, use a percentage number format and a title that identifies the measure. Do not assume that the left and right axes share a zero point or equivalent intervals.

Also check whether the chart needs two axes at all. If one series is merely hard to see because its values are smaller, a secondary axis may help, but it changes the visual comparison. If both series are meant to be compared by magnitude, a common axis is generally more transparent. If the purpose is to compare patterns rather than raw magnitudes, an explicitly labeled index or a pair of small charts may communicate that purpose better.

Distinguish bar overlap from axis-label overlap

The phrase two-axis overlap can also mean that axis titles, tick labels, or the chart legend collide with other chart elements. That is a different issue from columns covering each other. If the bars are readable but labels are crowded, widen or enlarge the chart, reduce the number of displayed categories, or adjust the font size. Rotating category labels may help when month names or long text labels run into one another.

For overlapping axis titles, select a title and move it, or resize the chart plot area to leave more room around the axes. A secondary vertical axis appears at the right, so a long right-axis title can be especially cramped. Keep units in axis titles where useful, such as Revenue in dollars or Rate in percent. Avoid adding a second axis simply to make more labels fit; it is a scale decision, not a spacing tool.

Common mistakes to avoid

  • Using two column series on different scales and assuming the bars are side by side. Check the rendered chart; separate axes do not guarantee a shared cluster.
  • Removing an axis to make the design look cleaner. Without the right-side scale or a clear label, readers may not know how to interpret the secondary series.
  • Comparing column heights across different axes. A bar’s height is meaningful only against its own scale, so a taller bar does not automatically represent a larger value.
  • Changing Series Overlap without checking the axis assignment. The setting may improve spacing within a group but still leave the two axis groups superimposed.
  • Using a secondary axis for a series with no clear reason. If the measures share units and a useful range, one axis usually makes comparisons simpler.

Frequently Asked Questions

Can I make two column series on different axes appear side by side?
Excel does not reliably cluster columns across primary and secondary axis groups as if they shared one scale. Try changing one series to a line. If both must remain columns, use a common axis only when valid, or create aligned charts with separate scales.

Does Series Overlap fix columns on a secondary axis?
Not necessarily. Series Overlap adjusts the positioning of columns within a chart group, but series on separate axes can still share the same category position. It is worth checking, but it is not a dependable way to create a true side-by-side cluster across axes.

How do I add a right-side axis in Excel?
Use Chart Design > Change Chart Type > Combo, choose a chart type for each series, and select Secondary Axis for the series that needs its own scale. Add an axis title so the right-side scale’s units are clear.

Should I use a line or a column on the secondary axis?
A line is often clearer for a rate or trend that would otherwise cover columns, especially when the categories have a natural order such as months. Use a secondary-axis column only when the column form is important and you can present the overlap or use another layout without confusing the comparison.

Can I use two axes if the data units differ?
Yes, Excel supports separate vertical scales, but readers can misread apparent heights across the axes. Label both scales, explain the units, and consider whether a line or two separate charts would make the comparison more transparent.

Related

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.