ExcelBanter - Secondary Axis

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Secondary Axis (https://www.excelbanter.com/charts-charting-excel/54406-secondary-axis.html)

Alex Mackenzie

Secondary Axis

Is it possible to have two different scales for the vertical axis, e.g. left
hand axis is 0-100, right hand (secondary) axis as 0-10?

Thank you.

Andy Pope

Secondary Axis

Hi,

Certainly. Once you have some data on the secondary axis double click it
to set the min and max values as required.

Cheers
Andy

Alex Mackenzie wrote:
Is it possible to have two different scales for the vertical axis, e.g. left
hand axis is 0-100, right hand (secondary) axis as 0-10?

Thank you.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 09:11 AM.