Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Add Secondary Axis To Chart. Select the data series for which you want to add a secondary axis. The Insert Chart dialog will show you a preview of the available chart types.
Make Row 1 your X-axis and Rows 2 and 3 your two Y-axes. Click OK to insert the chart. Select Secondary Axis for the data series you want to show.
You can add the secondary axis to an Excel chart from the.
Create a chart with your data. In out example we set line chart for the dataset that contains whole numbers Capture Rate. 7 right click Sum of Sales series and select Format Data Series from the popup menu list. You can add the secondary axis to an Excel chart from the.