How to Add a Second Y Axis to a Microsoft Excel Chart
It would be helpful if you knew how to add multiple data lines to an Excel chart. However, with data with many units, you may find it difficult to create the graph you need. Don't worry, not only can you do it, you can do it very easily!
Add a second Y axis
Create a chart in excel, assuming that all have the same units.
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.
Select "Format Data Series".
Under "Axis," select the radio button next to "Secondary Axis."
Select OK, you will see the second Y axis appear on the graph.
Change the chart type of the second dataset
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.
Select "Change Series Chart Type" (Change series chart type)
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
Maybe you are interested
Create Autotext in Word 2007, edit documents faster Alignment in Word 2010, beautiful alignment of Word 2010 documents How to master numerical data in Google Sheets with the AVERAGE function How to Justify Text in Cells on Excel - Adjust Text Spacing How to create Progress Bar in Excel, conditional progress bar How to strikethrough text in Word, write strikethrough text in Word and Excel