help with charting please

[KRK]

Hello,

I am trying to develop a complex chart & need help and advice please.

I have 4 data series that I want to plot on the Y axis. The X axis is the
same for all 4 series. The first 2 series have values between £0 and £6, and
I want to plot them as vertical bars against the left-hand (primary) Y axis.
The 3rd & 4th series have values between -10.0 and +25.0, and I want to plot
them as a line chart against the right-hand (secondary) Y axis.

Can I do all this on one chart, and if so how do I go about it ?

Thanks

KK

PS I have Excel 2007

 

[trip_to_tokyo]

KRK:-

Question please: do you want all your numbers running up the Y (vertical
axis)?

 

[KRK]

Hi,

Yes, £0 to £6 on the left (primary) axis, -10.0 to +25.0 on the right
(secondary) axis.

Thanks

KK

 

[KRK]

Hello again

I have been doing some experiments and I think I am trying to put too much
data onto one chart. I need to think about this a bit more.

Thanks for looking.

KK