Hi

I have a fairly simple chart based on source data containing percentages and
currency values. Y axis is for currency, X axis is timeline and secondary
axis is % - how do i integrate the Y and the secondary axes so that if the
currency values range from 150 000 to 1 500 000, the secondary axis % is in
relation to the value ?

Debi

How exactly do you want to relate the % values on the secondary axis to
the actual values on the primary axis? Especially since the idea
behind a % is that it is dimension-less!

Nonetheless, you might want to check
AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi

I have a fairly simple chart based on source data containing percentages and
currency values. Y axis is for currency, X axis is timeline and secondary
axis is % - how do i integrate the Y and the secondary axes so that if the
currency values range from 150 000 to 1 500 000, the secondary axis % is in
relation to the value ?

Debi