Autoscale a Line Chart to stack the curves

[Patachoup]

hello!

To compare financial market assets moves I use a single chart with 2 series.

The chart has 2 vertical axes and the scales are pretty different in term of
values.

The autoscale works fine on both axes.

My queston is:

How do I translate a curve onto the other so that they get "stacked", to be
easily compared at a glance ?

Any VBA function or sub is welcome...

Thx

 

[John Mansfield]

This post might help. It shows how to calculate a proportional axis on a
dual-axis chart. The effect is to plot the movement of one series against
another to see how well they are correlated. Because each axis is calculated
as proportional to the other, both series are viewed in the same plane i.e.
no one series over or understates the visual effect of one against the other.

http://www.cellmatrix.net/index.php/proportional_axis_calculations

 

[Patachoup]

Of course I can use proportionality ;-)

BUT I do not want to change the value of my currency! So no way to have an
axis with wrong figures, even if I can still fiddle something and mimic
displaying good figures on my chart!

I am looking forward applying distorsion to the second axis so that the
curves fit, without changing the values ;-)

Bloomberg HMS function does it very well, but the method is known to be a
non linear algorithm...fussy isn't it ?!

Give me your mail and I'll send you a screenshot if you want ;-)

Would you dare taking up this challenge ? LoL

++

 

[Kelly O'Day]

Patachoup:

Panel charts are one technique for showing stacked charts. this link gives
you several examples. If you decide to go the panel chart route, let me know
if you need help.

http://processtrends.com/toc_panel_charts.htm

Kelly

http://processtrends.com

 

[Patachoup]

Hi,

Indeed panel charts let us display stacked series onto a single chart, nice
technique I knew as well but that does not fit my needs! ;-)

Look at this picture and you will see what I mean:

 

[Kelly O'Day]

Patachoup:

Have you considered a custom Y Axis (aka dummy axis)?

This link will get you to a tutorial on custom axes.
http://processtrends.com/pg_charts_custom_axis.htm

Kelly O'Day

http://processtrends.com

Hi,

Indeed panel charts let us display stacked series onto a single chart,
nice
technique I knew as well but that does not fit my needs! ;-)

Look at this picture and you will see what I mean:

Patachoup:

Panel charts are one technique for showing stacked charts. this link
gives
you several examples. If you decide to go the panel chart route, let me
know
if you need help.

http://processtrends.com/toc_panel_charts.htm

Kelly

http://processtrends.com