Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Tertiary Y Axis
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tertiary Y-axis | Excel Discussion (Misc queries) | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Charting a tertiary scale | Excel Discussion (Misc queries) | |||
How do I add a tertiary Y axis in excel? | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |