#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.charting
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tertiary Y-axis SU Excel Discussion (Misc queries) 0 August 4th 08 08:14 PM
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
Charting a tertiary scale paulabrozek Excel Discussion (Misc queries) 1 May 12th 06 03:48 PM
How do I add a tertiary Y axis in excel? jdemaioribus Charts and Charting in Excel 4 October 8th 05 10:04 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"