How to Swap Chart Axes in Excel (Move Series to Secondary Axis)
Question details
The user needs to assign the Price data series to the vertical axis in a supply-and-demand chart while keeping the quantity values on the primary axis.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating an economic supply-and-demand chart where convention requires Price on the vertical axis and Quantity on the horizontal axis.
- Observed behavior
- The Price series is incorrectly plotted on the primary horizontal axis alongside quantity data, requiring an axis swap or secondary axis assignment.
Ensure your chart is already inserted into the worksheet, and verify that your source data is organized in clean columns with distinct headers for Price, Quantity Demanded, and Quantity Supplied.
Assign the Price Series to a Secondary Axis
This method moves a specific data series (like Price) to a secondary vertical axis, separating it from the primary horizontal data for proper supply-and-demand formatting.
By assigning one of the data series to a secondary axis, you can plot numbers with vastly different scales or units on the same chart without compressing the smaller values.
Click directly on the 'Price' data series line or bars within your existing Excel chart to select it.
Right-click the selected series and choose 'Format Data Series' from the context menu.
In the Format Data Series pane that appears on the right side of your screen, look under 'Series Options' and select the 'Secondary Axis' radio button. This will move the Price values to a new vertical axis.
To clean up the chart visually, select the redundant horizontal-axis labels and change their font color to white (or match your chart background) to hide them.
Use the Switch Row/Column Feature
If your entire chart's X and Y axes are inverted, you can quickly flip them using the Select Data tool without altering your spreadsheet cells.
Create and Customize Combo Charts with WPS Spreadsheet
WPS Spreadsheet offers a highly intuitive chart editor that makes swapping axes, creating secondary axes, and building complex economic charts effortless. It provides full functionality for advanced data visualization without the high cost.
- 1. Insert a Combo Chart: Select your data range, navigate to the 'Insert' tab, click 'Chart', and choose the 'Combo' chart type.
- 2. Enable Secondary Axis: In the chart creation dialog, simply check the 'Secondary Axis' box next to your Price series and click OK.
- 3. Customize Chart Elements: Use the 'Chart Elements' shortcut next to your generated chart to quickly adjust axis titles, gridlines, and legends.
Frequently Asked Questions
Why is the Secondary Axis option greyed out in Excel?
This usually happens if you are using a chart type that does not support secondary axes, such as a 3D chart, pie chart, or a surface chart. You must change your chart type to a 2D Line, Column, Bar, or Combo chart to enable the Secondary Axis feature.
How do I change the chart type of just one data series?
Right-click the specific data series in your chart and select 'Change Series Chart Type'. This action opens the Combo Chart dialog where you can assign different chart types (e.g., changing one series to a line while keeping the others as columns) and manage secondary axes for individual series.
Can I swap the X and Y axes without changing my spreadsheet source data?
Yes. You can use the 'Switch Row/Column' feature found in the Chart Design tab on the ribbon. This tells Excel to interpret the data differently, swapping how the X and Y axes are plotted directly in the chart without moving any data cells in your worksheet.
