When you create a combo chart in PowerPoint, you often need to plot two data series that use different value ranges. For example, you might show revenue in dollars on one axis and profit margin as a percentage on another. Without a secondary axis, the smaller-scale data becomes flat and unreadable. This article explains how to add a secondary vertical axis to a combo chart in PowerPoint so both data series display clearly.
Key Takeaways: Setting a Secondary Axis in a Combo Chart
- Chart Design tab > Add Chart Element > Axes > Secondary Vertical: Inserts the second axis for the selected data series.
- Format Data Series pane > Series Options > Secondary Axis: Moves the chosen series to the new axis and scales it independently.
- Right-click a data series > Change Series Chart Type: Lets you assign a different chart type (column, line) to each series before adding the second axis.
What a Secondary Axis Does and When You Need It
A secondary axis is an additional vertical axis that appears on the right side of the chart. It uses its own scale, independent of the primary axis on the left. This is essential when your data series have different units or vastly different numeric ranges.
A combo chart combines two chart types, such as a column chart and a line chart, on the same plot area. The primary axis scales the column series. The secondary axis scales the line series. Without the second axis, the line series would be compressed near the bottom of the chart and show no meaningful variation.
There are no special prerequisites for this feature. You need a chart in a PowerPoint slide that already contains at least two data series. The chart must be created as a combo chart or converted to one. You can complete all steps using the ribbon menus or the right-click context menu.
Steps to Add a Secondary Axis to a Combo Chart
These instructions work in PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, and PowerPoint 2016. The interface is identical across these versions.
- Select the chart and open the Format Data Series pane
Click the combo chart on your slide to select it. Right-click the data series you want to move to the secondary axis. In the context menu, choose Format Data Series. The Format Data Series pane opens on the right side of the PowerPoint window. - Choose the Secondary Axis option
In the Format Data Series pane, under Series Options, find the Plot Series On section. Select the Secondary Axis radio button. PowerPoint immediately adds a secondary vertical axis on the right side of the chart and rescales the selected series independently. - Adjust the chart type for each series if needed
Right-click any data series in the chart and select Change Series Chart Type. In the Change Chart Type dialog, confirm that one series uses Column and the other uses Line. You can also assign different chart types here. Click OK to apply. - Format the secondary axis labels and scale
Right-click the secondary axis numbers on the right side of the chart. Choose Format Axis. In the Format Axis pane, adjust the Minimum, Maximum, and Major Unit values under Axis Options > Bounds. This ensures the axis scale fits your data without distortion. - Add axis titles for clarity
Click the chart to select it. Go to Chart Design > Add Chart Element > Axis Titles. Select Primary Vertical to add a title for the left axis. Select Secondary Vertical to add a title for the right axis. Type the unit labels such as Revenue and Profit Margin.
Method 2: Using the Add Chart Element Menu
- Select the chart and open the Chart Design tab
Click the combo chart. The Chart Design tab appears in the ribbon. Click it. - Add the secondary axis from the ribbon
In the Chart Layouts group, click Add Chart Element. Hover over Axes. Click Secondary Vertical. A secondary axis appears on the right. However, this method may not automatically assign a data series to the new axis. You must still right-click the desired series and set it to Secondary Axis in the Format Data Series pane.
Method 3: Create the Combo Chart With a Secondary Axis From Scratch
- Insert a combo chart
Go to Insert > Chart. In the Insert Chart dialog, select Combo from the left pane. PowerPoint shows a preview with two data series and a dropdown for each series. - Assign the chart type and axis for each series
For the first series, choose Clustered Column from the chart type dropdown. For the second series, choose Line. Check the Secondary Axis box for the line series. Click OK. The chart is created with a secondary axis already active.
Common Mistakes When Setting a Secondary Axis
The secondary axis does not appear after selecting the option
This happens when you select the chart itself instead of a specific data series. The Secondary Axis option in the Format Data Series pane is only available when a single series is selected. Click directly on the column or line of the series you want to move. The selection handles should appear on that series only, not on the entire chart area.
Both axes show the same scale
If both the primary and secondary axes display identical minimum and maximum values, the data series are still plotted on the same scale. This occurs when you add the secondary axis from the ribbon but forget to assign a series to it. Right-click the series that should use the secondary axis and set Plot Series On to Secondary Axis in the Format Data Series pane.
The chart type changes unexpectedly after adding the secondary axis
PowerPoint may automatically convert both series to the same chart type when you add a secondary axis through the ribbon. To prevent this, always use the Format Data Series pane to assign the secondary axis. Then verify the chart types by right-clicking a series and choosing Change Series Chart Type. Set each series to the type you want.
Combo Chart With Secondary Axis: Chart Type Comparison
| Item | Column + Line (Recommended) | Column + Column |
|---|---|---|
| Visual clarity | High — different shapes distinguish series | Low — overlapping columns confuse viewers |
| Axis independence | Fully independent scales via secondary axis | Requires secondary axis but columns overlap |
| Best use case | Revenue (column) and profit margin (line) | Two metrics with very different ranges |
| PowerPoint default behavior | Assigns line to secondary axis automatically | Both series stay on primary axis until changed |
A combo chart works best when you pair a column series with a line series. The column represents the larger-scale data, and the line shows the smaller-scale data on the secondary axis. Avoid using two column series because they overlap and hide each other.
After you set the secondary axis, you can format the line series with a different color or marker style to make it stand out. Right-click the line series and choose Format Data Series to adjust line width and marker shape. This improves readability during presentations.
For advanced control, explore the Axis Options in the Format Axis pane. You can set the axis to display in units of thousands or millions. This prevents large numbers from crowding the axis labels. The option is located under Display Units in the Axis Options section.