Alignment of Graphs

[Mnilo]

Hi all:

I want to present in an Excel sheet two graphs of lines

- one will go under the other one
- both have the same number of data to represent
- both graphs have different scales in the vertical axis (since they
represent different variables).

What I would like to know is how I can achive that every data series point
of the top graph is exactly on every data series point of the low graph
without doing it by hand.

Any suggestion?

Thanks in advance

 

[Tim Williams]

Scattet plots support two different y-axes (select the series on the plot and double-click, then choose "axis" tab).
Can you not use that functionality?

Tim

 

[Mnilo]

I told 2 graphs to simplify the question but I really need to align 7
graphs. So this funcionality is not enaugh.

Thanks anyway.