How to make a stackable column chart with 4 data points?

[javajoe]

Help Needed: How can I make a stackable column chart that properly reflects the following table?

Month	Product A Target	Product B Target	Product A Actual	Product B Actual
1-Jul	5	0	5	1
1-Aug	6	0	6	0
1-Sep	7	0	7	0
1-Oct	8	0	8	0
1-Nov	9	0	9	0
1-Dec	10	5	10	5

<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>
</tbody>

I can get the chart wizard to reflect one "stack" reflecting columns B and C, but can't seem to figure out how to get two "stacks" side by side for each month that reflect the four data points I am trying to convey.

Thanks in advance for your help!

-JavaJoe

 

[oldbrewer]

visit jon peltier's website...

 

[javajoe]

Wow. Great resource but there has GOT to be a simpler way to accomplish something similar than the approach described here: https://peltiertech.com/?s=stacked+column

 

[oldbrewer]

Another way is to make identically sized charts, make them transparent, and lay them on top of one another...