How to Add a Second Y Axis to a Microsoft Excel Chart
Add a second Y axis
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 1
Create a chart in excel, assuming that all have the same units.
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 2
Go to the chart and right-click on the line of the data system to which you want to add a Y axis. In this example, if you want to add a Y axis for percentages, right click on the red line.
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 3
Select "Format Data Series".
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 4
Under "Axis," select the radio button next to "Secondary Axis."
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 5
Select OK, you will see the second Y axis appear on the graph.
Change the chart type of the second dataset
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 6
Back on the chart, right-click on the line of the data system to which you want to add a Y axis. In this example, if you want to add a Y axis for percentages, right click on the red line.
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 7
Select "Change Series Chart Type" (Change series chart type)
How to Add a Second Y Axis to a Microsoft Excel Chart Picture 8
Select the chart type for which you want to add the second data series. In this example it is a column graph.
You should read it
- Modify the axis of the chart in Excel
- How to Add a Second Y Axis to a Graph in Microsoft Excel
- How to draw a line chart in Excel
- 8 types of Excel charts and when you should use them
- Steps to use Pareto chart in Excel
- How to create a pie chart in Microsoft Excel
- How to create a bar chart in Excel
- How to make a thermometer template in Excel
- How to Make a Pie Chart in Excel
- Steps to reset chart in Excel
- How to fix chart position in Excel
- 'Moving' chart in Excel