How to Combine Two Excel Graphs with Separate Y-Axes
Question details
The user needs to display two distinct data series on a single chart using separate vertical axes to accommodate different data scales.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Comparing two datasets with significantly different ranges (e.g., total sales revenue vs. profit margin percentage) within the same visual graph.
- Observed behavior
- A clear method is required to combine the series and format one of them to map to a secondary Y-axis.
Ensure your data is organized with clear column headers, and both datasets share a common category (such as dates or product names) for the X-axis before creating the chart.
Format Data Series to Add a Secondary Axis
The most reliable way to combine graphs is to insert a standard chart containing both data series, then format one specific series to utilize a secondary vertical axis.
When you plot data with vastly different numerical scales on a standard chart, the series with smaller numbers often appears flat against the bottom axis. By moving one series to a secondary Y-axis, Excel creates an independent scale on the right side of the chart, allowing both trends to be clearly visible.
Highlight your entire data range (including both data series and the X-axis labels). Go to the 'Insert' tab on the ribbon, click the 'Insert Column or Bar Chart' icon, and choose 'Clustered Column'.
In the newly created chart, click on the data series (the bars or lines) that you want to move to the secondary axis. If the values are too small to click, go to the 'Format' tab under Chart Tools and select the series from the 'Chart Elements' dropdown box.
Right-click the selected data series and choose 'Format Data Series' from the context menu. This will open a formatting pane on the right side of your screen.
In the Format Data Series pane, under 'Series Options' (the column chart icon), find the 'Plot Series On' section and select the 'Secondary Axis' radio button. A new Y-axis will immediately appear on the right side of the chart.
Right-click the series you just moved to the secondary axis and select 'Change Series Chart Type'. Change it to a 'Line' chart to make the dual-axis chart easier to read and differentiate.

Easily Combine Graphs and Add Secondary Axes in WPS Spreadsheet
WPS Spreadsheet provides an intuitive and user-friendly chart wizard that makes combining data series and enabling secondary Y-axes incredibly simple. You can effortlessly build professional combo charts for complex datasets without getting lost in complicated formatting menus.
- 1. Select your dataset: Open your workbook in WPS Spreadsheet and highlight the data columns you wish to chart, including headers.
- 2. Insert a Combo Chart: Navigate to the 'Insert' tab, click on 'Chart', and select 'Combo' from the left-hand menu to automatically mix lines and columns.
- 3. Activate the Secondary Axis: In the chart insertion window, simply check the 'Secondary Axis' box next to the data series you want mapped to the right-hand scale.
- 4. Customize and Apply: Click 'OK' to generate the chart. You can double-click any axis or series to open the properties pane for further styling.

Frequently Asked Questions
Why can't I see my second data series to click on it in the chart?
If one data series has numerical values significantly smaller than the primary series, it may appear completely flat against the X-axis. To select it, go to the 'Format' tab under Chart Tools on the ribbon, and use the 'Current Selection' dropdown menu in the top-left corner to precisely select the hidden series.
How do I add descriptive titles to my secondary Y-axis?
Click on your chart to reveal the 'Chart Elements' button (the plus icon) at the top right of the chart. Hover over 'Axis Titles', click the right arrow, and check the box for 'Secondary Vertical'. A text box will appear on the right axis where you can type your title.
Can I have three or more Y-axes on a single Excel chart?
No, Excel and most spreadsheet programs natively support a maximum of two vertical axes (one primary and one secondary). To visualize three or more scales, you will need to either normalize your data to a common scale (like percentages) or create separate, aligned charts.




