add a secondary y axis to a graph in excel for mac

Optional: Next to 'Apply to,' choose the data series you want to appear on the right axis.Double-click the chart you want to change.On your computer, open a spreadsheet in Google Sheets.How do I add a second vertical axis in Google Sheets? In the Format Data Series dialog box, with the Series Options category selected, choose Secondary Axis, to plot that series on a secondary axis. Right-click the selected series and choose Format Data Series. Related Question How do you add a second axis? How do you add a secondary axis in Powerpoint?

How do I add a secondary axis title in Excel? The chart Axis tab contains (Y1) and (Y2) tabs which you can customise.The Series tab for each data series will allow you select which axis to use for each series and the type: columns, lines or areas.Make sure you have more than one data series selected.Select the chart, change the type to 2D 2-Axis.How do I add a secondary axis in numbers? You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis. To add a measure as a dual axis, drag the field to the right side of the view and drop it when you see a black dashed line appear. How Do You Add A Second Axis? On December 13, 2021ĭual axes are useful for analyzing two measures with different scales.

Add a secondary y axis to a graph in excel for mac