Excel Graph Two Y-Axes: How to Add a Secondary Axis

Charts & pivot tables · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, select the chart, then go to Chart Design > Change Chart Type > Combo, choose a chart type for each data series, and check Secondary Axis for the series that needs its own scale. Excel will show the primary Y-axis on the left and the secondary Y-axis on the right.

What a chart with two Y-axes means

A chart with two Y-axes, also called a secondary-axis chart, plots two or more series against the same horizontal categories but gives one series a separate vertical scale. The left axis is usually the primary axis; the right axis is the secondary axis. Each axis has its own range, units, and formatting, while the plotted points share the chart’s horizontal positions.

For example, a monthly sales chart might show revenue in dollars and profit margin as a percentage. Revenue could range from $0 to $100,000 while margin ranges from 0% to 20%. Putting both series on one dollar scale would make the percentage line hard to see or meaningless. A second axis lets Excel plot each series on a scale that suits its units.

A second axis does not convert one measure into the other or make the values directly comparable. It only provides a separate scale for displaying them together. That distinction matters when interpreting the apparent relationship between the lines or columns.

When a secondary axis is useful

Consider a second Y-axis when two measures belong in the same time-based or category-based story but have substantially different units or magnitudes. Common examples include:

  • Revenue and profit margin, such as dollars and percentages.
  • Website visits and conversion rate, such as sessions and percent.
  • Units sold and average selling price, such as item counts and currency.
  • Rainfall and temperature, when both are recorded for the same dates.

The key is that the series should share a meaningful horizontal dimension, such as month, product, or year. If they do not, placing them in one chart may imply a connection that the data does not support. A secondary axis is also not automatically necessary just because one series appears smaller. First check that the values and number formats are correct, and consider whether a different chart or separate charts would communicate the data more clearly.

How to add a second Y-axis in Excel

For a clear starting point, arrange the data with categories in the first column and each series in its own column. For example, put months in column A, revenue in column B, and margin percentages in column C. Select the full range, including the headers, and insert a chart. A line chart or a column-and-line combination is often suitable for data tracked over time.

  1. Select the chart so the chart tabs appear on the ribbon.
  2. Open Chart Design > Change Chart Type.
  3. In the chart type window, select Combo. If Excel offers a suggested combo, choose the custom combo option so you can set each series separately.
  4. Use the chart-type list beside each series to choose how it should appear, such as Clustered Column for revenue and Line for margin.
  5. Check the Secondary Axis box beside the series that needs a separate scale. In this example, that would usually be margin.
  6. Select OK. Excel places the secondary vertical axis on the right side of the chart.

You can also assign an existing series to the secondary axis directly. Right-click the series in the chart, choose Format Data Series, and under Series Options select Secondary Axis. On a Mac, Control-clicking the series can open its context menu; the Format Data Series pane has the corresponding axis option. The ribbon names are broadly similar in current desktop Excel for Mac, though the layout can differ by release.

Excel for the web may not expose every chart-formatting control available in the desktop application. If you cannot find Combo or the secondary-axis checkbox in the browser, open the workbook in desktop Excel and make the change there.

Choose chart types and format both axes

For many comparisons, use columns for one measure and a line for the other. The columns emphasize totals or amounts, while the line makes a rate or trend easy to follow. A two-line chart can also work when both measures change continuously over time, but use different colors and make it obvious which line belongs to which axis. Avoid assigning similar-looking series to separate axes without clear labels.

After assigning the secondary axis, add titles that identify each measure and unit. Select the chart, then use Chart Design > Add Chart Element > Axis Titles. Choose Primary Vertical for the left axis and Secondary Vertical for the right axis. The secondary title option is relevant after a secondary axis has been added. Use descriptive titles such as Revenue ($) and Margin (%) rather than generic labels such as Series 1.

To change an axis scale, right-click or Control-click its labels and choose Format Axis. In the Format Axis pane, Axis Options lets you adjust bounds and units where appropriate; the Number section controls how values display. For a percentage series, check that the underlying values and number format agree. A stored value of 0.15 formatted as a percentage displays as 15%, whereas a stored value of 15 formatted as a percentage displays as 1,500%.

Excel chooses axis bounds automatically by default. You can set a minimum and maximum when a consistent scale is important, but do not choose bounds merely to make a trend look more dramatic. If you change bounds, keep the axis title and tick labels visible so readers can judge the actual scale.

How to decide which series gets the right axis

Usually, put the measure that defines the main story on the primary, left axis and the differently scaled measure on the right. For instance, if the chart is principally about monthly revenue, keep revenue on the left and put margin on the right. This convention is not a technical requirement; it is a way to make the chart easier to read.

Choose the series based on units and readability, not on which arrangement makes the lines appear to move together. Because each axis can have different bounds, changing those bounds can make two series appear more or less closely aligned without changing any data. If readers need to compare the size of values rather than their timing or direction, separate charts with clearly stated scales may be more honest and easier to understand.

Also consider whether the second measure is a rate, a total, or an index. Rates and percentages often work well on a secondary axis beside a count or currency series, provided the chart identifies the units. If the values are already on comparable scales and share units, a single axis is generally simpler.

Common problems and how to fix them

  • The secondary axis option is missing. Make sure you selected a data series rather than the chart background, and check that the chart type supports the combination you want. In desktop Excel, changing the chart to a Combo chart is a reliable route.
  • The wrong series moved. Select the series by clicking one of its plotted marks, then open Format Data Series and confirm the selected series name before choosing Secondary Axis.
  • The percentage scale looks wrong. Inspect the source values. Percentages are commonly stored as decimals, such as 0.2 for 20%, and then formatted as percentages. Do not multiply values by 100 and also apply percentage formatting unless that is intended.
  • The line or columns are hard to distinguish. Use a contrasting color, a different chart type, or markers for the line. Update the legend and axis titles so each series and scale can be identified without guessing.
  • The chart suggests a misleading relationship. Check both axes’ minimums and maximums, and explain the separate units. If the scales make the comparison confusing, use separate charts instead.

If a series has missing values or its categories do not line up with the others, check the source range and chart selection. A secondary axis changes the vertical scale, not the horizontal categories. It will not correct mismatched dates, missing observations, or incorrectly selected data.

Secondary axis versus separate charts

A dual-axis chart is compact and can help readers see whether two measures rise, fall, or change at similar times. It is most useful when a shared timeline is central to the question and both scales can be labeled clearly. Its drawback is interpretive: the separate scales can make unrelated series appear visually synchronized, or conceal differences in magnitude.

Two aligned charts are often preferable when readers need to examine each measure precisely, when the units are very different, or when the axes would need complicated bounds. Small multiple charts can share the same horizontal time scale while retaining a separate vertical scale in each panel. Another alternative is to index both series to a common starting point, such as setting the first period to 100, but that changes the question: it compares relative change rather than original units. State that transformation clearly if you use it.

A single-axis chart is the simplest option when the series use the same unit and a sensible common scale. The best choice depends on the question readers need to answer, not on the fact that Excel makes a second axis available.

Frequently Asked Questions

Can Excel have two Y-axes?
Yes. A chart can have a primary vertical axis and a secondary vertical axis. Use a Combo chart or Format Data Series to assign a series to the secondary axis.

How do I put a line on the right axis in Excel?
Select the chart, open Chart Design > Change Chart Type > Combo, set the chosen series to Line, and check Secondary Axis for that series. Select OK to apply the change.

Can I add a second Y-axis to a bar chart?
Excel supports secondary axes for many two-dimensional chart types, but a combination chart is often the clearest way to pair a column series with a line on the right axis. Some chart types, including 3-D charts, do not support every secondary-axis combination.

Why does my secondary axis start at a different number?
Excel sets each axis bounds independently, often using automatic bounds. Right-click the axis, choose Format Axis, and review Axis Options. A different starting value is not necessarily an error, but it should be visible and appropriate for the comparison.

Can I add a second Y-axis in Excel for the web?
Chart editing options in Excel for the web can differ from the desktop version. If the Combo or Secondary Axis controls are unavailable in your browser, open the workbook in desktop Excel for Microsoft 365 and use Chart Design > Change Chart Type > Combo.

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.