How to Add a Second Y-Axis to a Microsoft Excel Chart

You are viewing the article How to Add a Second Y-Axis to a Microsoft Excel Chart  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

It would be helpful if you knew how to add multiple data lines to an Excel chart. However, with multi-unit data, you may find it difficult to create the graph you need. Don’t worry, not only can you do it, but it’s also very easy!

Table of Contents

Steps

Add a second Y-axis

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/60/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1- Version-2.jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-2.jpg”,”bigUrl”:”https: //www.wikihow.com/images/thumb/6/60/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-2.jpg/v4- 728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth” :728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Create a chart in excel, assuming that all have the same units.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d7/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2- Version-2.jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-2.jpg”,”bigUrl”:”https: //www.wikihow.com/images/thumb/d/d7/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-2.jpg/v4- 728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth” :728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Go to the chart and right click on the data system line to which you want to add the Y axis. In this example, if you want to add the Y axis for the percentage, right click on the red line.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/17/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3. jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/1/17/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3.jpg/v4-728px-Add-a-Second-Y-Axis- to-a-Graph-in-Microsoft-Excel-Step-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Select “Format Data Series”.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/86/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4- Version-2.jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-2.jpg”,”bigUrl”:”https: //www.wikihow.com/images/thumb/8/86/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-2.jpg/v4- 728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth” :728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Under “Axis”, select the radio button next to “Secondary Axis”.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/00/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5- Version-2.jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-2.jpg”,”bigUrl”:”https: //www.wikihow.com/images/thumb/0/00/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-2.jpg/v4- 728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth” :728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Select OK, you will see the second Y-axis appear on the graph.

Change the chart type of the second data system

READ More:   How to Submit iTunes Credits

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ec/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6- Version-2.jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-2.jpg”,”bigUrl”:”https: //www.wikihow.com/images/thumb/e/ec/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-2.jpg/v4- 728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth” :728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Back on the chart, right click on the line of the data system to which you want to add the Y axis. In this example, if you want to add the Y axis for the percentage, right click on the red line.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c0/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7. jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/ images/thumb/c/c0/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7.jpg/v4-728px-Add-a-Second-Y-Axis- to-a-Graph-in-Microsoft-Excel-Step-7.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Select “Change Series Chart Type”

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d5/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8- Version-2.jpg/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-2.jpg”,”bigUrl”:”https: //www.wikihow.com/images/thumb/d/d5/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-2.jpg/v4- 728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth” :728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Select the chart type to which you want to add the second data series. In this example is a column graph.

Advice

• You can create three or more Y axes in Excel using EZplot or Multy_Y from OfficeExpander.com. Use the trial first to be more sure of your needs.
• You can pre-apply on simple data samples to use more proficiently.

It would be helpful if you knew how to add multiple data lines to an Excel chart. However, with multi-unit data, you may find it difficult to create the graph you need. Don’t worry, not only can you do it, but it’s also very easy!

Thank you for reading this post How to Add a Second Y-Axis to a Microsoft Excel Chart at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

Related Search: