View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
KRK KRK is offline
external usenet poster
 
Posts: 91
Default help with charting please

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


"trip_to_tokyo" wrote in message
...
KRK:-

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



"KRK" wrote:

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

.