How to Add a Secondary Axis in Excel: Step-by-Step Guide
Learn how to add a secondary axis in Excel to compare two data series with different scales. This practical guide covers Windows and Mac, with clear steps, best practices, and tips to keep charts readable and accurate.
In this guide, you will learn how to add a secondary axis in Excel to visualize two data series with different scales on a single chart. The steps cover common versions (Windows and Mac), how to keep axes aligned, and practical tips to avoid clutter, misinterpretation, and mislabeling by following a clear, repeatable workflow.
Why a secondary axis matters
Excel charts are powerful, but they can mislead if two data series have very different scales. A secondary axis lets you plot both series on the same chart while giving each series its own scale, making trends easier to compare without distorting one series. This approach is especially useful for metrics like revenue (in thousands) and units sold, percentages vs. absolute counts, or temperature vs. precipitation. When used sparingly and with clear labeling, a secondary axis adds insight rather than confusion. In this section, we explore the rationale behind using a secondary axis and common scenarios where it truly adds value, so you can decide when it’s appropriate for your data story.
When to consider a secondary axis in Excel
Not every chart benefits from a secondary axis. The key is to ensure that the two data series have a logical relationship and that the chart remains easy to read. If one series dominates visually or if the audience will misinterpret the axes, a different approach may be preferable (e.g., separate charts or a small multiples layout). Helpful signs that a secondary axis is warranted include: large differences in scale between series, a need to preserve relative differences while still showing absolute values, and a goal to show co-movement or lag between metrics. This section lays out decision criteria to help you avoid chart clutter and ensure your visualization communicates clearly.
Choosing chart types that support dual-axis visualization
Excel supports several chart types that work well with a secondary axis, including Combo charts (where one series is plotted as columns and the other as a line), Line charts with a separate axis, and certain Scatter variations. The combo chart is often the simplest route because it provides built-in controls to assign a series to the Secondary Axis. In contrast, stacked charts or charts with many data series can become unreadable when a second axis is added. This section helps you pick the right chart type for your data story and sets expectations for what Excel can do.
Practical example: two-series dataset
Imagine monthly data for two metrics: Revenue (in dollars) and Units Sold (thousands). Plot both on a single chart using a Combo chart with Revenue on the primary axis (columns) and Units Sold on the secondary axis (lines). By choosing distinct colors and labeling axes clearly, you can reveal seasonality and trend without distorting either measure. This example demonstrates the power of the secondary axis while highlighting the importance of proper axis labeling and a clean legend. The underlying principle is to keep the chart legible while accurately representing both series.
Best practices for readability and avoiding misinterpretation
To maximize clarity when using a secondary axis, keep the chart simple: limit to two data series, use contrasting colors, and provide concise axis titles. Avoid cherry-picking scales that exaggerate differences, and always include a clear legend. If the audience is likely to print the chart, preview print settings to ensure axis labels remain legible. Finally, document your logic in the workbook notes so future readers understand why a secondary axis was used and what each axis represents.
Authority sources and credibility
For official guidelines and examples, consult trusted sources that explain axis configuration and chart interpretation. Microsoft’s support and Learn documentation cover charting basics and advanced axes configurations, while university data visualization resources provide conceptual context. Together, these sources help ensure your technique aligns with best practices and audience expectations.
Getting your data ready before you start
Before you build the chart, ensure your data is well-structured: a single header row, a clean category axis (dates or categories), and two numeric series with aligned rows. Remove or address missing values, and resize the dataset so the chart remains readable. Having a tidy data table makes the subsequent steps smoother and reduces the need for backtracking if you need to adjust the axis scale later.
Tools & Materials
- Excel (Windows or macOS, 2016 or later)(Ensure you have a recent version with the Combo chart option)
- Two numeric data series(Example: Monthly Revenue and Units Sold)
- Sample workbook with aligned categories(Structured data with a common category axis (months or categories))
- Backup copy of the workbook(Always keep a version before chart changes)
Steps
Estimated time: 15-25 minutes
- 1
Create a combo chart with both data series
Select the data range that includes both series and the category axis. Go to Insert > Charts > Combo, then choose a Column for one series and a Line for the other. This sets up a chart that can accommodate a secondary axis without losing clarity for either metric.
Tip: If Combo isn’t visible, choose a Clustered Column chart first and switch the chart type afterward. - 2
Move the appropriate series to the secondary axis
Click the data series you want on the secondary axis. Choose Format Data Series, then select Secondary Axis. The chart updates to reference a second Y-axis on the right side.
Tip: If the right axis isn’t showing, add the Axis option in Chart Elements to ensure it’s visible. - 3
Adjust axis scales for readability
Right-click each axis and choose Format Axis. Set minimum/maximum values or units so both series fit comfortably within the chart area. Avoid forcing identical scales if the data ranges are very different.
Tip: Use Auto for one axis and fixed limits for the other to control visual balance. - 4
Improve labeling and color-coding
Add or edit axis titles to clearly indicate what each axis represents. Use distinct colors for each data series and ensure the legend is visible and easy to interpret.
Tip: Prefer high-contrast colors and a legend placed away from the data to minimize occlusion. - 5
Validate readability and accessibility
Check the chart at different zoom levels and on print preview. Confirm that both axes’ scales are legible and that the chart remains interpretable for someone who hasn’t seen the underlying data.
Tip: Ask a colleague to review the chart for potential misinterpretation. - 6
Document and save your approach
Add a brief note in the workbook explaining why a secondary axis was used and what each axis represents. Save the workbook with a descriptive filename.
Tip: Keeping a note helps future readers understand your data-story decisions.
People Also Ask
What is a secondary axis in Excel and when should you use it?
A secondary axis is a second Y-axis added to a chart to plot a second data series that has a different scale. It should be used when the two series have different ranges or units and you want to compare their trends without distorting either series.
A secondary axis adds a second Y-axis to compare two series with different scales and is helpful when the units differ significantly.
Which charts support a secondary axis in Excel?
Most commonly, Combo charts and Line charts support a secondary axis. In a Combo chart, you can assign one series to the primary axis and another to the secondary axis for direct comparison.
Combo charts in Excel support a secondary axis, letting you place one series on the primary axis and another on the secondary axis.
What are common pitfalls when adding a secondary axis?
Common pitfalls include mislabeling axes, exaggerating differences by improper scaling, and overloading the chart with more than two series. Always test readability and use clear titles.
Watch out for confusing labels, skewed scales, and charts with too many series that muddy the point.
How do I remove a secondary axis once added?
To remove it, select the data series on the secondary axis, open Format Data Series, and deselect Secondary Axis. Alternatively, delete the axis from Chart Elements.
Select the series, turn off the secondary axis, or remove the axis via Chart Elements.
Can I have more than one secondary axis in a chart?
Excel supports one primary and one secondary axis per chart. If you need additional dimensional comparison, consider separate charts or a dashboard design approach.
You can have only one secondary axis per chart; for more dimensions use additional charts.
Is there a quick keyboard shortcut to create a secondary axis?
There is no single dedicated keyboard shortcut to add a secondary axis. The task is performed through the chart tools menu by selecting the data series and choosing Secondary Axis.
There isn’t a built-in shortcut; you navigate the menu to assign the secondary axis.
Watch Video
The Essentials
- Use a Combo chart to enable a secondary axis
- Label axes clearly and pick distinct colors
- Keep scales reasonable to avoid misinterpretation
- Preview on screen and in print to ensure readability
- Document reasoning in workbook notes
