Questions and answers
255In an Excel chart, can I have different Y-axis scales (a primary and secondary axis)?
Yes, in Excel 2013 and Excel 2016 you can have two axes.
Excel 2013 and Excel 2016
- Start by creating a chart with just one axis.
- Select the data series you wish to place on a secondary axis, by clicking on the series in the chart.
- From the Format tab, Current Selection Group, check you have the correct data series selected and then click Format Selection.
- The Format Data Series dialog box will be displayed.
- From Series Options category, under Plot Series on, click Secondary Axis radio button and then click Close.
Help us to improve this answer
Please suggest an improvement
(login needed, link opens in new window)
Your views are welcome and will help other readers of this page.