Tertiary Y Axis

[~~NRH~~]

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

 

[Andy Pope]

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