Excel Pivot Chart Secondary Y Axis: How to Add One

Yes. In Excel for Microsoft 365 on Windows, select a PivotChart data series, open Format Data Series, and under Series Options choose Secondary Axis. That places the series on a second vertical scale, usually shown on the chart’s right side; PivotCharts still have limitations, especially when you want a combo chart with different chart types.

What a secondary y-axis does

A chart normally uses one vertical, or y, axis to scale every plotted series. That works when the values are reasonably comparable. It becomes hard to read when one series is much larger than another, or when the series use different units. A secondary y-axis gives one selected series its own scale, while the other series continue using the primary axis.

For example, monthly sales might range from $40,000 to $90,000, while a conversion rate ranges from 2% to 6%. If both series use the same scale, the rate can look almost flat at the bottom of the chart. Plotting the rate on a secondary axis makes its changes visible. The chart then has two scales, so readers need clear axis titles and units to understand what each line or set of columns represents.

In Excel, the primary vertical axis is usually on the left and the secondary vertical axis is usually on the right. The horizontal category axis is shared. Adding a second vertical axis does not create a second set of months, products, or other categories.

How to add a secondary axis to a PivotChart

First, make sure the series you want to separate is actually plotted in the chart. In a PivotChart, fields in the Legend (Series) area commonly create separate series, while fields in Axis (Categories) provide the category labels. A field in Values supplies the numbers being plotted.

Click the PivotChart, then click the specific series you want to move. Click a data point or line belonging to that series; clicking the chart background selects the chart, not the series.
Right-click the selected series and choose Format Data Series. If selecting it in the chart is difficult, use the Chart Format tab’s Current Selection list to choose the series, then select Format Selection.
In the Format Data Series pane, open Series Options and select Secondary Axis.
Check that the second vertical axis appears on the right. Add or edit axis titles so the units and series are unambiguous.

The exact pane layout can vary slightly with Excel updates and window size, but the setting is in the selected series’ formatting options. If the chart has only one series, there is usually little benefit to assigning it a second axis; add or retain another series on the primary axis so the two scales have a useful comparison.

Choose the right PivotChart series

Changing the axis is a series-level setting, not a way to assign an entire PivotTable field to a scale regardless of how it is plotted. Before formatting, inspect the PivotChart Fields pane and identify which series corresponds to the measure you want to separate. A chart with several product categories may have many series, so confirm the legend name before moving one.

A useful example is units sold and revenue by month. If units are in the hundreds and revenue is in the tens of thousands, the scales are different and a second axis may help. But if both measures are amounts of money with similar ranges, one axis may be easier to interpret. A second scale should solve a real readability problem, not simply make every line look more dramatic.

Also check whether the PivotChart is summarizing the measures in a meaningful way. The Values area might be set to Sum, Count, or Average. If a conversion rate is being summed across records, the chart may be misleading before you ever change its axis. Review the value field’s summary and any filters or slicers that affect the displayed figures.

Format and label both vertical axes

Once the series is on the secondary axis, give each scale enough context to stand on its own. Select an axis title and enter a descriptive label such as Revenue ($) or Conversion rate (%). If axis titles are not visible, select the chart and use Chart Design > Add Chart Element > Axis Titles to add the relevant vertical titles. The secondary vertical title may be positioned differently from the primary one, so check that it is readable and does not overlap the chart.

Format the right axis to match its measure. For a percentage, use percentage number formatting; for currency, use a suitable currency or number format. Right-click the axis and choose Format Axis to review its number format, bounds, and major units. Automatic bounds are convenient, but they can change the apparent emphasis as PivotChart filters change. Set bounds deliberately only when they make sense for the data, and do not hide meaningful variation by choosing an artificially narrow range.

Keep the legend clear, too. If a series name is a field label such as Sum of Value, consider improving the source field name or chart labeling where possible. A reader should be able to tell which series uses the right-hand scale without guessing. Axis titles, a clear legend, and consistent colors are more useful than relying on color alone.

PivotChart restrictions and combo charts

A secondary axis and a combo chart are related but different features. A secondary axis changes the scale used by a series. A combo chart changes the chart type of one or more series, for example using columns for revenue and a line for a rate. PivotCharts do not provide the same full combo-chart options as ordinary charts, so you may not be able to turn one PivotChart series into a line while leaving another as columns through Excel’s standard combo-chart workflow.

If the secondary-axis option is unavailable, disabled, or the chart will not behave as required, consider whether the chart type or PivotChart structure is the obstacle. Some chart types and combinations are restricted for PivotCharts. Changing the entire PivotChart type is not the same as changing one series’ type. Avoid assuming that every feature available for a regular chart will also be available for a PivotChart.

PivotCharts are linked to their PivotTables: filtering fields, changing the layout, or refreshing source data can alter which series are present. After making those changes, check that the intended series is still plotted on the secondary axis and that the scale and labels remain appropriate. If the series disappears and later returns, verify its formatting rather than assuming the axis assignment was preserved in every situation.

Common problems and practical fixes

The whole chart is selected. Click a plotted point or line again to select its series, or choose the series by name in the Current Selection list.
The second axis does not appear. Confirm that you selected a data series, not an axis, legend, or chart area, and then choose Secondary Axis in Series Options.
The series is hard to identify. Use the legend and the PivotChart Fields pane to match the plotted series to its field. Temporarily filtering to fewer categories can make selection easier.
The chart looks misleading after the change. Check both axis bounds and units. Independent scales can make two trends look closely related even when their numerical changes are not comparable.
A refresh changes the display. Refresh the PivotTable or PivotChart, then check which series remain and whether the correct one still uses the secondary scale.

Another common misunderstanding is that moving a series to a secondary axis converts its values or changes the PivotTable calculation. It does neither. Excel still plots the underlying summarized values; the second axis only changes how those values are mapped to chart height.

When a regular chart is a better choice

If you need a column-and-line combination, detailed control over individual series, or a chart layout that PivotCharts do not support, create a regular chart from a small summary range based on the PivotTable results. Select the relevant cells and insert a standard chart, then use Chart Design > Change Chart Type to choose a combo chart when that option is appropriate. In the combo chart settings, assign the suitable series to a secondary axis.

The trade-off is that a regular chart is not the same automatically field-driven PivotChart. Its source range may need attention if the PivotTable changes size or its layout changes. A standard chart based on a fixed range can omit new rows or include unwanted cells after a refresh. Check the chart source whenever the summary structure changes, or use a deliberate source range that accommodates the expected data.

For comparisons where two scales might confuse readers, other options include separate charts with the same category order, a table alongside a single-scale chart, or an indexed view that expresses both measures relative to a chosen starting point. These alternatives can make the comparison clearer without asking readers to interpret two independent vertical scales.

Frequently Asked Questions

Can an Excel PivotChart have a secondary y-axis?
Yes. Select the series, open Format Data Series > Series Options, and choose Secondary Axis. Availability can depend on the chart and series configuration.

How do I put only one PivotChart series on the right axis?
Select that series rather than the chart as a whole, then choose Secondary Axis in its formatting pane. The other series remain on the primary axis unless you move them as well.

Can I make a PivotChart a line-and-column combo chart?
PivotCharts have restrictions and do not offer the full combo-chart workflow available for ordinary charts. If you need different chart types for different series, a regular chart based on the PivotTable summary is often the practical alternative.

Why is Secondary Axis missing or greyed out?
Check that a data series is selected and that the chart type and configuration support the setting. If the option remains unavailable, use a regular chart from the summarized data or choose a supported PivotChart arrangement.

Will the secondary axis update when I filter the PivotChart?
The axis scales respond to the values currently plotted, but the series on the axis and its formatting should be checked after filtering or refreshing. If a series is removed and later reintroduced, confirm its axis assignment and labels.

Is a secondary axis always the clearest choice?
No. It helps when measures have different units or substantially different ranges, but two independent scales can exaggerate visual similarity. Label both axes clearly and consider separate charts if the comparison could be misread.

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.