Yes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Change Chart Type > Combo, set the relevant series to Clustered Column, and select its Secondary Axis checkbox. One important limitation: column series on separate axes may overlap rather than form one clean side-by-side cluster, so a secondary axis is not automatically the best solution.
What a secondary axis does
A clustered column chart compares values across categories by placing columns next to one another. The primary vertical axis on the left supplies the scale for the series assigned to it. A secondary vertical axis, usually displayed on the right, supplies a separate scale for series assigned to that axis. Both axes share the chart’s category positions along the bottom.
This can make a small-valued series visible beside a much larger one. For example, monthly revenue might range from $20,000 to $60,000 while the number of customer complaints ranges from 5 to 40. If both series use one vertical scale, the complaint columns may look almost flat. A second scale can make their changes easier to see.
The axes do not convert one measure into another or make the underlying numbers comparable. They simply map different numeric ranges onto the same chart area. A column’s height must therefore be read against the axis assigned to its series. Label the axes clearly so readers do not mistake the visual heights as a direct comparison.
When this chart is useful
Use a secondary axis when two measures share the same categories and time periods but have substantially different numeric ranges or units. A useful example is monthly sales revenue and the number of orders: both are reported by month, but dollars and orders cannot share a meaningful numeric scale. Putting the order series on a secondary axis can make its variation visible.
It is less useful when the measures are already on similar scales, when the categories are not aligned, or when the chart would require readers to keep switching between two scales. Consider whether the purpose is to compare patterns or to compare actual magnitudes. A dual-axis chart can reveal that two measures rise and fall together, but it cannot establish that one caused the other.
- Good candidate: units sold and revenue by month, if the chart needs to show both series as columns and readers can identify the two scales.
- Often clearer: revenue as columns and order count as a line on the secondary axis. The different shape helps distinguish the series and reduces column overlap.
- Poor candidate: two measures with similar ranges, because one shared axis is simpler and easier to interpret.
Create the chart and assign a secondary axis
Organize the worksheet with one category column and one column for each measure. For example, put months in column A, revenue in column B, and order count in column C, with headings in row 1. Select the complete data range, including headings, then choose Insert > Insert Column or Bar Chart > Clustered Column. Check that Excel has used the months as categories and the measures as separate series.
- Select the chart. On the ribbon, open Chart Design > Change Chart Type.
- In the chart-type window, choose Combo. If needed, choose Custom Combination.
- For each series, select the chart type you want. To keep columns, choose Clustered Column for the relevant series.
- Tick Secondary Axis beside the series that needs its own scale. Leave the other series on the primary axis.
- Select OK, then inspect the chart. Add axis titles and a legend or direct labels so the two scales are unmistakable.
You can also select a series in the chart, right-click it, choose Format Data Series, and under Series Options select Secondary Axis. This is a quick way to move one existing series to the right-hand scale. The combo-chart window is generally more convenient when you also need to change a series from columns to a line.
On current Excel for Mac, select the chart and use the Chart Design tab and Change Chart Type to reach the combo-chart choices; the dialog’s layout may differ from Windows. In Excel for the web, chart-editing options can be more limited or arranged differently, so use the desktop app if the needed combo or secondary-axis control is not available in your workbook.
Why two column groups can overlap
A frequent surprise is that assigning some columns to the primary axis and others to the secondary axis does not reliably produce a single cluster with every bar sitting side by side. Excel treats series on the two axes as separate plotting groups. Each group can use the same category positions, so columns from the two groups may be drawn over one another. One series can hide another, or the bars can appear unusually narrow or oddly spaced.
This is a chart-layout limitation, not evidence that the secondary-axis assignment failed. Confirm the assignment by selecting each series and checking Format Data Series > Series Options, or by opening the combo-chart dialog again. If both series are set to columns and belong to different axes, judge the result by how the bars actually render rather than assuming Excel will create one shared cluster.
Excel provides controls such as Series Overlap and Gap Width in the series-formatting pane, but they may not make two separate axis groups behave like one native, side-by-side cluster. More elaborate helper-series layouts can create visual spacing, but they take careful setup and can be fragile when data or categories change. For a chart that must be straightforward to maintain and interpret, choose a different design if the columns obscure one another.
Choose axis bounds and labels carefully
Excel normally chooses axis bounds and units automatically. Its choices may change when data is added, removed, or edited. To inspect or adjust a scale, right-click the relevant vertical axis, choose Format Axis, and use Axis Options. You can set minimum and maximum bounds, major units, and number formatting. Check both axes after any adjustment: the left and right scales need not start or end at the same values.
For columns, a vertical axis that starts above zero can exaggerate apparent differences because the bars no longer share a visible baseline. A nonzero minimum may sometimes be appropriate for a specific analytical reason, but make the choice explicit and consider whether a line chart would communicate the variation more honestly. Avoid choosing bounds merely to make two series look more similar or more dramatically different.
Give each axis a descriptive title, such as Revenue ($) and Orders, and use series names that match the legend. Format the right-hand axis with the units its data uses; do not format a count as currency or imply that a percentage is a raw count. If a chart is copied into a report, keep both axis titles and the legend with it.
Alternatives when clustered columns are hard to read
A combo chart with columns on the primary axis and a line on the secondary axis is often the clearest option for mixed scales. For example, show revenue as columns and order count as a line. Readers can distinguish the two measures by both position and mark type, and the line does not cover another column in the same way. In the combo dialog, choose Clustered Column for one series and Line for the other, then assign the line to the secondary axis if appropriate.
If the goal is to compare the direction or seasonality of two measures, separate charts with aligned month categories may be more transparent. They can use independent scales while keeping each chart to one measure. If the measures can be expressed in a meaningful common unit, such as percentage change from a defined starting month, a normalized chart can compare movement on one axis—but the transformation and reference point must be stated clearly.
Another option is to put the measures in adjacent panels or use a table with small charts. These designs give each measure its own visible scale and avoid the dual-axis reading burden. For a presentation where viewers need exact values, direct data labels or a small supporting table can help, but do not label every column if doing so makes the chart crowded.
Common problems and practical checks
- The bars disappear or sit on top of one another: check which axis each series uses, then consider changing one series to a line or separating the charts.
- The wrong series moved: select the intended series carefully. Clicking a column selects a series or sometimes an individual data point; verify the series name in the formatting pane before changing its axis.
- The category labels look wrong: use Chart Design > Select Data to check the chart’s data range, series names, and horizontal category labels.
- The secondary axis seems misleading: add axis titles and check the minimum and maximum values. Two scales with different ranges can make similar trends look unusually alike or unlike one another.
- The chart changes after updating data: review automatic axis bounds, category ranges, and the plotted series. A chart that was readable for one data range may need a new scale or layout when new periods are added.
Before sharing the chart, ask someone unfamiliar with the worksheet to identify which scale applies to each measure. If they cannot do that quickly, improve the titles, legend, colors, or chart type. Color alone is not enough for readers who print in grayscale or have difficulty distinguishing colors.
Frequently Asked Questions
Can a clustered column chart have a secondary axis in Excel?
Yes. Use a combo chart and select the secondary-axis option for the series that needs a separate scale. However, columns assigned to different axes can overlap instead of forming one shared side-by-side cluster.
How do I add a secondary axis to only one series?
Select the chart, open Chart Design > Change Chart Type > Combo, and tick Secondary Axis for that series. Alternatively, right-click the selected series, choose Format Data Series, and select Secondary Axis under Series Options.
Why are my columns overlapping after I add the secondary axis?
Excel plots the primary-axis and secondary-axis column series in separate groups that can occupy the same category position. The secondary-axis setting gives a series a separate scale; it does not guarantee side-by-side spacing with columns on the other axis. Change one series to a line or use separate charts if the overlap obscures values.
Can I put both column series on the same axis instead?
Yes. If their units and ranges make a shared scale meaningful, keep both series on the primary axis in a standard clustered column chart. This avoids the dual-scale interpretation and generally makes direct comparisons easier.
Should the secondary axis start at zero?
For column charts, zero is usually the clearest baseline because column length represents magnitude. If you set a different minimum, do so for a specific reason, make the scale easy to see, and consider whether another chart type would communicate the data more fairly.
Related
- Contact Number List Template for Excel: Setup Guide
- Contacts List Template Excel: Build a Useful Workbook
- Contact List Excel Template: Free Options and Setup
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Create a Combo Chart in Excel: Steps and TipsTo create a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert >…
- Traffic Light Chart in Excel: Build a Status DashboardA traffic light chart in Excel is a visual status indicator that uses green, yellow, and red symbols…
- How to Make a Chart in Excel Run From Right to LeftTo make an Excel chart read from right to left, select the axis you want to reverse, right-click…
- Excel Line Chart With Shaded Area: How to Make OneTo make an Excel line chart with a shaded area beneath the line, create a combo chart from…
- Dynamic Charts in Excel Using the OFFSET Function ExplainedYes. In Excel for Microsoft 365 on Windows, you can make a chart expand as new rows are…
- Excel Chart With Drop-Down List: How to Create OneYes. In Excel for Microsoft 365 on Windows, create a drop-down with Data Validation, use a helper column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.