Content

• Steps
• Advice

It is very helpful if you know 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, it's not only possible but it's also very easy!

Steps

Method 1 of 2: Add the second Y axis

1. 

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

2. 

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

3. 

   
   
   Select "Format Data Series".

4. 

   Under "Axis", select the radio button next to "Secondary Axis".

5. 

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

Method 2 of 2: Change the chart type of the second data system

1. 

   Back in the chart, right click on the straight 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 a percentage, right click on the red line.

2. 

   Select "Change Series Chart Type".

3. 

   Select the chart type for which you want to add a second data series. In this example it is a bar graph. advertisement

Advice

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