Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with charting please
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with charting please
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 . |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with charting please
Hi,
Yes, £0 to £6 on the left (primary) axis, -10.0 to +25.0 on the right (secondary) axis. Thanks 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 . |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting | Excel Discussion (Misc queries) | |||
charting add in | Charts and Charting in Excel | |||
charting help | Charts and Charting in Excel | |||
Boy do I need your help with charting! | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |