Thread: Tertiary Y Axis
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Tertiary Y Axis

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