View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Double Stacked Bar with Line Chart

Hello all,

I believe I'm trying to accomplish the impossible, but I'm hoping someone
might have an answer.

I'm trying to create a double stacked bar chart, with a line chart. I've
managed to create a double stacked bar chart, but I can't get a line chart.
I want the line chart to straddle the groups.

If you create a Stacked Bar chart with a Line Chart (on second axis), you'll
see what I'm trying to accomplish. Just imagine 2 stacked bars instead of
one.

Like I said, trying the impossible.

Here's the data setup I've got for two stacked bar charts. It's going to
look ugly, but I hope it makes sense.

_____________stackedbar1__|__stackedbar2_|
______________Jan-07_____|____Feb-07____|
____________Budget_Actual_|_Budget_Actual_|
Development_|_20____10___|__30_____32___|
Test________| 15____7____|__12_____16___|
Qty Delivered_|_____34_____|______32______| <-- this would be the line chart

Hope that helps. I'd appreciate any suggestions on how this could work.

Thanks,
Jay
--
Disregard, this is so I can find my post later.
***postedbyJay***