Autoscale a Line Chart to stack the curves

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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

++
 
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:



eurofuturesav6.gif
 
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



Patachoup said:
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:



eurofuturesav6.gif



Kelly O'Day said:
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
Click to expand...
Click to expand...
 
Back
Top