2 Charts on 1 Graph: 2 Y-axis?

[Mike]

Hi everyone,

Say you have two charts that you want to put on Y-axis: I mean the left
Y-axis for one, and the right Y-axis for the other.

How can you do that?

Thanks,
Mike

 

[Guest]

Right click the series that you want to change to the secondary axis. A menu
will appear. Select 'Format Data Series'. Select 'Axis' tab. Select
'Secondary'.
HTH,
Gary Brown

 

[crossingmind]

I think the easiest way is:
1. highlight your data array
2. click the graph icon, select the tab "custom types"
3. select Line/column on two axes type of graphs. Select the type you
want (line-line, or column-line).
4. Then you'll get the two y axis chart.

 

[Mike]

Big THANK YOU all...........