To make an Excel column chart use two y-axes, select the chart and choose Chart Design > Change Chart Type > Combo; set the relevant series to a column chart and check Secondary Axis. If you are starting from data, select the data, choose Insert > Insert Combo Chart > Create Custom Combo Chart, then assign the series and axis there.
What a two-axis column chart does
A chart with two y-axes, also called a secondary-axis chart, uses two vertical scales for data series that share categories but have very different values or units. The primary vertical axis is usually on the left; the secondary vertical axis appears on the right. For example, a chart might show monthly sales revenue as columns on the left axis and a percentage measure on the right.
Excel does not convert or combine the values when you add a second axis. Each series keeps its own values and is positioned against its assigned scale. The categories along the horizontal axis—months, products, or regions, for instance—remain shared. This can make different measures visible in one chart, but it also means the apparent height of a mark depends on which scale it uses.
A two-axis chart is not automatically clearer than two separate charts. It is most useful when the measures have a meaningful relationship and need to be compared over the same categories or period. If the measures are unrelated, putting them together can imply a connection that the data does not support.
Prepare the data before charting
Arrange the worksheet so that the first column contains category labels and each other column contains one data series, with a clear heading at the top. For instance, a monthly table might have Month, Orders, and Return rate as its headings. Each row should describe the same month across all series, and the category labels should be in the same order.
Check that the values are stored as numbers rather than text. Percentages should be entered or formatted consistently, and dates should be real Excel dates if you want Excel to recognize them as dates. Avoid blank rows inside the table, merged cells in the data range, and totals that you do not intend to chart. These issues can cause Excel to omit data or interpret the chart layout unexpectedly.
It is helpful to decide in advance which series belongs on each axis. Usually, the series with the most intuitive or primary unit goes on the left. A measure with a different unit or a much smaller numerical range may go on the right. Do not assign an axis merely to make a series look more dramatic; the assignment should reflect the measurement and the story the chart is meant to tell.
Create the chart in Excel for Windows
For a new chart in Microsoft Excel for Microsoft 365 on Windows, select the table including its headings, then use the Insert tab to open the combo-chart options. Choose Insert Combo Chart > Create Custom Combo Chart. In the dialog, Excel lists the data series and lets you choose a chart type and axis for each one.
- Set the series you want displayed as bars to Clustered Column.
- For the series that needs a separate scale, select the Secondary Axis checkbox.
- Choose an appropriate chart type for the other series. A line is often easier to read than a second set of columns.
- Review the preview and click OK.
If the chart already exists, click it and select Chart Design > Change Chart Type > Combo. Choose a type for each listed series, tick Secondary Axis for the intended series, and confirm. The dialog can also be used to change the series from columns to lines or vice versa. If you do not see a Combo option, confirm that the chart contains multiple data series; combo charts require more than one series.
Excel may choose the initial series arrangement automatically, so inspect the result rather than assuming the first series is on the left axis. To label the scales, select the chart and use Chart Design > Add Chart Element > Axis Titles. Add a primary vertical title and a secondary vertical title, then replace the placeholder text with meaningful labels such as Revenue ($) and Return rate (%). A chart title should also say what is being compared and, where useful, identify the period.
Set and format the two scales
Excel initially chooses the minimum and maximum for each axis automatically. That can be a sensible starting point, but the two scales are calculated independently. To inspect or adjust one, right-click its axis labels and choose Format Axis. In the Format Axis pane, review the bounds, units, number format, and other available axis options. Repeat for the other vertical axis if necessary.
Use a zero baseline for column charts in most comparisons. Since column length represents magnitude, starting a column axis above zero can exaggerate differences. If the data legitimately includes negative values, Excel can show values on both sides of zero; make sure the axis and chart make that clear. For a percentage series, use a percentage number format and choose bounds that accurately represent the range. A right axis running from 48% to 52%, for example, can make small changes look substantial if readers do not notice the truncated scale.
Independent scales can make two series appear to move together even when their relationship is weak, or make them look unrelated when they are connected. The visible crossing point between a line and columns is not a meaningful equality when the series use different units. Explain the scales with axis titles, appropriate number formats, and a note if the scale choice needs context. Avoid adjusting bounds simply to make a visual pattern appear stronger.
When two column series cause trouble
A common question is whether both series can remain columns when they use different axes. Excel can assign column series to primary and secondary axes, but this is often harder to interpret than a column-and-line combo. Columns grouped on separate axis groups may overlap or be positioned in a way that makes the category comparison unclear. The chart can look as though one series hides the other, even though both are present.
For many datasets, use columns for the measure you most want readers to compare and a line for the second measure. A line can show a trend without competing for the same category space. If both series genuinely need to be columns, inspect every category at normal viewing size, confirm that neither series is obscured, and make the legend and axis titles unambiguous. If the bars cannot be distinguished cleanly, do not force the format.
Alternatives include using two charts with a shared category axis, placing charts one above the other, or using separate panels with clearly labeled scales. If both measures have the same unit, a single-axis clustered column chart is generally easier to read. If the purpose is to compare relative movement rather than raw values, an indexed chart can be appropriate, but it requires deliberately transforming the values and clearly explaining the baseline. Do not present transformed values as the original measurements.
Make the chart readable and trustworthy
Use axis titles that name both the measure and its unit. A legend that says Series 1 and Series 2 is not enough; rename the source headings to useful labels or edit the series names through the chart’s data selection controls. Use distinct, accessible colors and do not rely on color alone to identify the series. Keep gridlines restrained so they help readers estimate values without overwhelming the marks.
Check that the category labels are in chronological or otherwise meaningful order. If Excel plots months alphabetically because they are text, correct the source order or use real dates. If there are many categories, rotate or shorten labels only when needed; reducing the number of categories or filtering the displayed period may be clearer than crowding the axis.
Consider who will read the chart and where it will appear. A chart that is readable on a large monitor may become difficult to interpret in a printed report or narrow presentation slide. Make sure the right-side axis is not clipped, the legend does not cover data, and labels remain legible when resized. Add a concise note when the dual scales could be mistaken for a direct comparison of heights.
Common problems and fixes
- The secondary axis option is missing: Check that the chart has at least two data series and that you are in the Combo chart settings. A single-series chart has no second series to assign.
- The wrong data appears on the right: Open Chart Design > Change Chart Type > Combo and check which series has Secondary Axis selected. You can change the assignment in that dialog.
- A series is absent or looks flat: Check its source range and the axis bounds. A scale chosen for a much larger series can compress a smaller series visually. Confirm that the smaller series has actually been assigned to the secondary axis.
- Columns cover one another: Try a line for one measure or move to separate charts. Two-axis columns may not provide a clear side-by-side comparison.
- Axis labels show unexpected numbers: Use Format Axis to check the number format and bounds. A percentage stored as 0.05 may display as 0.05 rather than 5% if the axis format is not set appropriately.
On Excel for Mac, the names and placement of chart controls can differ slightly by release, but the task is the same: change the chart to a combo type and assign a series to the secondary axis. In Excel for the web, chart editing controls can vary; if the custom combo settings you need are unavailable, open the workbook in the desktop Excel app to make the change.
Frequently Asked Questions
Can an Excel column chart have two y-axes?
Yes. Use a combo chart and assign one data series to the secondary vertical axis. The chart can include columns, but using columns for both axis groups may make the bars overlap or difficult to compare.
How do I add a right-hand y-axis in Excel?
Open Chart Design > Change Chart Type > Combo, then select Secondary Axis beside the series that needs the right-hand scale. Add a secondary vertical axis title using Chart Design > Add Chart Element > Axis Titles.
Can I use two different units on one Excel chart?
Yes, that is a common reason to use a secondary axis—for example, dollars and percentages. Label each axis with its unit and avoid implying that equal visual heights mean equal values.
Why are my two sets of columns overlapping?
Excel separates series into primary and secondary axis groups, and columns on those groups do not always form a clear side-by-side cluster. Use a column-and-line combo or separate charts if the bars obscure one another.
Should both y-axes start at zero?
For columns, a zero baseline is generally the clearest choice because bar length encodes magnitude. Any nonzero baseline should be justified, clearly visible, and used with care so it does not exaggerate differences.
Choosing the clearest option
A secondary axis is a display choice, not a statistical adjustment: it makes two differently scaled series fit into one frame, but it does not make their values directly comparable. Use it when the measures share categories, the comparison is meaningful, and each scale can be labeled clearly. For the common case of one large-value measure and one percentage or rate, columns plus a line are usually the most readable arrangement. When a dual-axis chart needs extensive explanation, two aligned charts may communicate the evidence more honestly.
Related
- Close Group Excel Shortcut: Close Workbooks and Rows
- Close Excel Shortcut: Windows and Mac Keys
- Checklist Template Excel: Set Up, Track, and Reuse Tasks
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Plot a Waterfall Chart in Excel Step by StepTo plot a waterfall chart in Excel, arrange your categories in one column and the changes in value…
- How to Set Up a Pie Chart in Google Sheets EasilyTo set up a pie chart in Google Sheets, put category names in one column and their numeric…
- Excel Pivot Table Count vs Count Numbers ExplainedIn an Excel PivotTable, Count counts nonblank entries, including text and numbers, while Count Numbers counts numeric entries…
- Create a Gantt Chart in Excel with a Pivot Table?Yes—but a PivotTable does not have a built-in Gantt view. In Excel for Microsoft 365 on Windows, summarize…
- Spider Web Graph in Excel: Create and Format OneIn Excel, a spider web graph is usually called a radar chart. To create one in Microsoft Excel…
- Filter in Power Pivot: Ways to Narrow PivotTable DataTo filter Power Pivot data, add the Data Model to a PivotTable and use its field drop-downs, report…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.