To add a secondary axis to an Excel graph, select the chart, choose Chart Design > Change Chart Type, select Combo, and check Secondary Axis for the data series that needs a separate scale. You can also right-click that series, choose Format Data Series, and select Secondary Axis under Series Options.
What a secondary axis does
A secondary axis gives one data series its own scale, usually displayed along the right side of the chart. The original, primary axis is typically on the left. Both axes belong to the same chart, but each can cover a different range and use different units. The values in the worksheet do not change; Excel is only changing how the chart maps those values to positions.
This is useful when one series has values much larger or smaller than another. For example, a monthly chart might show sales revenue in dollars and profit margin as a percentage. Revenue could range from $20,000 to $80,000, while margin ranges from 5% to 15%. Plotting both on one dollar scale would make the margin line appear almost flat at the bottom. A right-side percentage axis lets readers see its variation.
A secondary axis is not the same as adding a second chart. It overlays two series in the same plot area, so readers can compare their timing or movement. It does not make unlike units directly comparable: a point at the same height on each scale does not mean the values are equal.
When a second axis is appropriate
Consider a secondary axis when two meaningful series share a time period or category, but their units or magnitudes make a shared scale hard to read. Common examples include units sold alongside revenue, website visits alongside conversion rate, or temperature alongside energy use. A line for a rate or percentage is often paired with columns for counts or amounts.
- Use one axis when both series use the same units and their ranges are reasonably similar. A common scale makes the size of each value easier to compare.
- Consider a secondary axis when the series use different units, or one series would otherwise be compressed by the other’s much larger range.
- Use separate charts when readers need to compare exact magnitudes, when the series have unrelated categories, or when a second scale would make the chart confusing.
Different units alone do not automatically justify a second axis. A clearly labeled pair of small charts can be more honest and easier to interpret than two scales that happen to make unrelated trends look alike.
Add a secondary axis in Excel
These steps apply to Excel for Microsoft 365 on Windows. The Combo chart route is especially useful when you want columns for one series and a line for the other.
- Select the chart. If you have not made one yet, select the category labels and data, then choose Insert and a suitable chart type.
- With the chart selected, open Chart Design > Change Chart Type.
- In the chart-type window, choose Combo. Excel displays the chart type and axis options for each series.
- Choose an appropriate chart type for each series, such as Clustered Column for sales and Line for margin.
- Check Secondary Axis on the row for the series that needs its own scale. Usually only one series needs to move to the right axis.
- Select OK. Add or edit axis titles so readers can tell which units belong to each side.
If the chart is already in a useful form, click the specific data series, right-click it, and choose Format Data Series. In the formatting pane, open Series Options and select Secondary Axis. To switch it back, choose Primary Axis in the same options. Be sure you selected the series rather than a single data point or the chart background.
Choose a chart type and label both axes
Excel can place a series on a secondary axis without changing its chart type, but the result is not always clear. A common combination uses columns for totals and a line for a percentage or rate. The columns show volume, while the line makes the second measure visible across the same categories. The Combo settings let you select a chart type separately for each series.
Give both vertical axes descriptive titles and include units, such as Revenue ($) on the left and Margin (%) on the right. If a chart title or legend does not make the series obvious, rename the series in its source heading or chart data settings. Color can help connect a series to its axis, but do not rely on color alone: labels and distinct line or marker styles also help readers distinguish them.
Axis titles are available from Chart Design > Add Chart Element > Axis Titles. Choose the primary or secondary vertical axis title as needed, then click the title in the chart and type the wording. If the secondary axis is not available in that menu, first confirm that a series is assigned to it.
Set and format the axis scales
Excel usually chooses axis bounds and units automatically. That is convenient, but automatic scales can make a chart harder to explain or can exaggerate small differences. To adjust a scale, right-click the relevant axis labels and choose Format Axis. In the formatting pane, use Axis Options to set bounds and units where those controls apply. The exact controls depend on whether the axis is a value axis or a category axis.
For example, if a percentage series ranges from 8% to 12%, an automatic scale may show only that narrow interval. The line will look more dramatic than it would on a scale starting at 0%. A narrow range can be reasonable when the goal is to show small changes, but make the bounds visible or explain them so readers do not mistake the visual emphasis for a large absolute change.
Check the number format as well. A value such as 0.1 may represent 10% if the underlying data is stored as a decimal. If the axis is formatted as a plain number, readers may interpret it incorrectly. In Format Axis, use the Number section to choose an appropriate format, such as Percentage, Currency, or a number format with units. Confirm that the source values and displayed labels tell the same story.
Common problems and how to fix them
- The wrong series moved. Select the series itself, not the chart area, and check the series name in the formatting pane. In a crowded chart, clicking its legend entry can help select it.
- The second axis option is missing or unavailable. Confirm that a data series is selected and that the chart type supports the arrangement you want. Use Chart Design > Change Chart Type > Combo to assign the series and axis together.
- The line appears flat or the columns look odd. Inspect both axis bounds and units. A large gap in scale, inappropriate bounds, or an unsuitable chart type may be obscuring the pattern. Try a line for the smaller series or use separate charts.
- The labels are confusing. Add titles with units to both vertical axes and keep the legend names specific. A reader should not have to guess whether the right axis shows a percentage, count, or currency amount.
- The chart changes after adding data. Check the chart’s source range and series assignments. Newly included data may be plotted on the primary axis by default, so review the Combo settings after expanding the source data.
Secondary axis versus separate charts
A two-axis chart is compact and can make shared timing easy to spot, but it gives the designer considerable control over how the relationship looks. Because each scale can be adjusted independently, two series can appear to rise together even when their actual values have little connection. Matching the visual heights of lines does not prove correlation or causation.
Separate charts avoid the problem of comparing two scales in one plot area. They are often preferable for a report, dashboard, or presentation where accurate comparison matters more than saving space. If you use separate charts, align their category axes and time periods so readers can still compare when changes occurred. Another alternative is to convert one measure to an index or percentage change, but explain the calculation and baseline; that changes what the chart communicates.
Excel for Mac and Excel for the web
In Excel for Mac, chart options can be arranged differently from the Windows ribbon, but the same general approaches apply: select the chart and look for chart-type settings, or select a series and open its formatting options to assign it to a secondary axis. Ribbon labels and pane layouts can vary by release. In Excel for the web, chart editing capabilities may be more limited or presented differently; if the needed Combo or axis controls are not available, open the workbook in the desktop Excel app and make the change there.
Frequently Asked Questions
How do I add a secondary axis in Excel?
Select the chart and choose Chart Design > Change Chart Type > Combo. Check Secondary Axis for the series that needs a separate scale, then select OK. You can also right-click a series and use Format Data Series > Series Options > Secondary Axis.
Can I put a line on the secondary axis?
Yes. In the Combo chart settings, choose a line chart for that series and check its Secondary Axis box. A line paired with columns is a common way to show a percentage or rate alongside a total.
Why does my secondary axis start at a different value?
Excel sets bounds for each axis independently, and it may choose different automatic minimums and maximums. Right-click the axis, choose Format Axis, and review its bounds. Set them deliberately, and label or explain a truncated range if it could affect interpretation.
Can a chart have more than two axes?
Excel’s standard chart layout provides a primary and a secondary axis for a given direction, not a separate vertical scale for every series. If several measures need different units, consider multiple charts, or redesign the display so the comparisons remain understandable.
Does adding a secondary axis change my worksheet data?
No. It changes how the selected chart series is plotted and scaled, not the values in the cells. You can move the series back to the primary axis or change the chart type without altering the source numbers.
Related
- Excel Data Validation Rules: How They Work and When to Use Them
- Excel Data Validation Restrictions and Their Limits
- Data Validation Process: Steps, Checks, and Best Practices
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Make a Graph in Excel With Two Variables EasilyTo graph two numerical variables in Excel, put each variable in its own column, select the paired data,…
- Excel Logarithmic Trendline: How to Add and InterpretAn Excel logarithmic trendline is a curve that models how a value changes as the predictor grows by…
- Excel Pivot Table Manual Sort: Drag Items into OrderTo manually sort items in an Excel PivotTable, right-click an item label, choose Sort > More Sort Options,…
- How to Update Pivot Table Data in Google SheetsGoogle Sheets pivot tables update automatically when cells in their source range change. If you add rows or…
- Excel Waterfall Chart Data Format: Examples and SetupFor an Excel waterfall chart, use one column for category labels and one column for numeric changes, with…
- Excel Pivot Table Running Total: Setup and TroubleshootingTo show a running total in an Excel PivotTable, select a value in the Values area, right-click it,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.