help with charting please

K

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
 
T

trip_to_tokyo

KRK:-

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

KRK

Hi,

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

Thanks

KK
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I eliminate empty cells from plotting on chart 1
multiple y axis in xy chart 3
How do I put words as the Y axis values? 0
charting variable line data 1
charting variable length line data 1
multiple series bar and line chart 2
Help with Bar-Line Chart..not aligned?? 1
Excel Excel Dynamic Charting in rows 0

Top