View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Patachoup Patachoup is offline
external usenet poster
 
Posts: 19
Default Autoscale a Line Chart to stack the curves

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