255. In an Excel chart, can I have different Y-axis scales (a primary and secondary axis)? : Frequently asked questions : ... : ITS : �պ��

Questions and answers

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.

Please suggest an improvement
(login needed, link opens in new window)

Your views are welcome and will help other readers of this page.