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/...s_calculations

--
John Mansfield




"Patachoup" wrote:

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

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

++

"John Mansfield" wrote:

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/...s_calculations

--
John Mansfield




"Patachoup" wrote:

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

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" wrote in message
...
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

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" wrote:

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" wrote in message
...
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

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" wrote in message
...
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" wrote:

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" wrote in message
...
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