Mapping two axis on one diagram

[hgus393]

Hi All,

I wonder if someone could help me sort this out. I have data consisting of
7 columns
Column 1:Date
Column 2:Value1
Column 3:Value2
Column 4:Value3
Column 5:Percentage of Value1
Column 6:Percentage of Value2
Column 7:Percentage of Value3

How can I get a diagram to only show 3 line curves with percentage axis on the left and a value axis on the right?
Cheers
Bob

 

[Andrew Poulsom]

Right click the series and choose Format Data Series. On the Axis tab check Secondary axis and click OK.

 

[hgus393]

Hi,

Yeah I have tried this and this results in a diagram with six lines not three I am afraid.

 

[Andrew Poulsom]

Sorry, how can you have only 3 lines when you are plotting 6 series?

 

[hgus393]

Yes this is what I mean is it at all possible to have i my case only three curves where the left axis shows the percentage and the right axis shows the values...??
Bob

 

[Andrew Poulsom]

No, you would have 3 curves on the left axis and 3 curves on the right axis.

 

[hgus393]

Ok thanks!

Bob