ExcelBanter - Tertiary Y Axis

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

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

- - Tertiary Y Axis (https://www.excelbanter.com/charts-charting-excel/212570-tertiary-y-axis.html)

Hi,

Would anyone please be able to help me add a tertiary axis to an xy scatter
graph? Previous threads on this subject had a link to a site which once
contained this information but no longer does. Whilst I realise that having
three y-axes is not usually desirable this is a special case. I am using
Excel 2003.

Thanks

Hi,

Construction of the axis itself is straight forward. Use a variation of
Jon's arbitrary axis
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

You will of course need to rescale your data to this new scale.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"~~NRH~~" wrote in message
...
Hi,

Would anyone please be able to help me add a tertiary axis to an xy
scatter
graph? Previous threads on this subject had a link to a site which once
contained this information but no longer does. Whilst I realise that
having
three y-axes is not usually desirable this is a special case. I am using
Excel 2003.

Thanks