View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
jas580 jas580 is offline
external usenet poster
 
Posts: 1
Default 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