Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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*** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
how do I create a double stacked bar chart? | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
Line & Double Stacked Charts | Charts and Charting in Excel | |||
Stacked chart and line | Charts and Charting in Excel |