Add a Second Y Axis to a Graph in Microsoft Excel

It can be very helpful to put multiple data trends onto one graph in Excel. But, if your data has different units, you may feel like you can't create the graph you need. But have no fear, you can -- and it is actually pretty easy!

Steps

Adding a Second Y Axis

  1. Create your graph in excel as you would if all the units were the same.
  2. Go to the graph and right click on the line for the data set you want to add the additional Y axis for. In this example, if you want to add an additional y axis for the engagement percentage, click on the red line.
  3. Select "Format Data Series"
  4. Under "Axis" select the radio button for "Secondary Axis".
  5. Select OK and now you should see a second Y axis on your chart.

Changing the Chart Type of the Second Data Set

  1. Go back to the graph and right click on the line for the data set you want to add the additional Y axis for. In this example, if you want to add an additional y axis for the engagement percentage, click on the red line.
  2. Select "Change Series Chart Type"
  3. Select the type of chart that you want for your secondary data series. In the example here, I chose a column chart

Tips

  • You can create three or more Y axes in Excel using EZplot or Multy_Y from OfficeExpander.com. Try the demonstration version first, to be sure it's what you want.
  • You may want to try this out on some simple sample data to get the hang of it first.

Related Articles

Retrieved from "https://kipkis.com/index.php?title=Add_a_Second_Y_Axis_to_a_Graph_in_Microsoft_Excel&oldid=279024"