Content

• To step
• Method 1 of 2: Add a second y-axis
• Method 2 of 2: Change the chart type of the second data set
• Tips

It can be very useful to graph multiple data trends using Excel. But if the data has different units, you may think you cannot create the graph you need. No fear, you can - and it is very simple in principle!

To step

Method 1 of 2: Add a second y-axis

1. Create a chart in Excel as you would if all units were equal.
2. Go to the graph and right click on the line of the data set where you want to add the extra y-axis. For example, if you want to add an extra y-axis for the engagement rate, click the red line.
3. Select "Format Data Series".
4. Under "Axes", select the "Secondary Axis" radio button.
5. Select OK and a second y-axis should now appear on the graph.

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

1. Go back to the graph and right click on the line of the data set for which you want to add an extra y-axis. For example, if you want to add an extra y-axis for the engagement rate, click the red line.
2. Select "Other Graph Series Type...’
3. Select the chart type you want to use for your second data set. In this example, a column chart has been chosen.

Tips

• You can create three or more y-axes in Excel with EZplot or Multy_Y from OfficeExpander.com. Try the demo version first to make sure you want this.
• You may want to try this first using a simple data collection to give it a try first.