How Do You Add A Second Y Axis To A Graph In Microsoft Excel?
• Create your graph in excel as you would if all the units were the same. • 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 image, I want to add an additional y axis for the engagement percentage, so I clicked on the red line. • Select “Format Data Series” • Under “Axis” select the radio button for “Secondary Axis”. Select OK and now you should see a second Y axis on your chart. • 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 image, I want to add an additional y axis for the engagement percentage, so I clicked on the red line. • Select “Change Series Chart Type” Select the type of chart that you want for your secondary data series.
