Add Secondary Axis To Chart

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.

Highlight A Bar In A Chart Chart Highlights Gop
Highlight A Bar In A Chart Chart Highlights Gop from www.pinterest.com

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.