Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 Y Axes: Lines and a Stacked Column
Hello,
I'm using Excel 2003 SP3 and having trouble with the following... Sample data: X Axis Y Axis1 Y Axis1 Y Axis2 Y Axis2 Y Axis2 Date DataA DataB DataC DataD DataE 1/31/09 4.3 3.6 10% 40% 50% 2/28/09 2.9 1.9 30% 60% 10% 3/31/09 1.2 6.4 15% 10% 75% I need Y Axis1 to be two simple lines and Y Axis2 a stacked column that sums to 100%. Can't figure this out. Please advise... Thanks! Jeff |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2 Y Axes: Lines and a Stacked Column
First, clear the cell above the dates, so the top left cell is blank.
Since more than half of the Y data will be stacked 100% columns, make a chart of this type using your data. Right click on series 1 (Data A), choose Chart Type, and select a line. Repeat with series 2 (Data B). Right click on series 3, choose Format Series, in Excel 2003 or earlier choose Secondary on the Axes tab, in Excel 2007 it's on the main tab. Repeat for series 4 and 5. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "jas580" wrote in message ... Hello, I'm using Excel 2003 SP3 and having trouble with the following... Sample data: X Axis Y Axis1 Y Axis1 Y Axis2 Y Axis2 Y Axis2 Date DataA DataB DataC DataD DataE 1/31/09 4.3 3.6 10% 40% 50% 2/28/09 2.9 1.9 30% 60% 10% 3/31/09 1.2 6.4 15% 10% 75% I need Y Axis1 to be two simple lines and Y Axis2 a stacked column that sums to 100%. Can't figure this out. Please advise... Thanks! Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a stacked, staggered column graph w/ 2 y axes | Charts and Charting in Excel | |||
Stacked bar and lines on 2 axes | Charts and Charting in Excel | |||
stacked bar, and column, two axes | Charts and Charting in Excel | |||
Stacked/clustered column chart with a two vertical axes | Charts and Charting in Excel | |||
Line Column on 2 axes that shows stacked colums | Charts and Charting in Excel |