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?

[TABLE="width: 320"]
<colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Month
[/TD]
[TD="class: xl63, width: 64"]Product A Target[/TD]
[TD="class: xl63, width: 64"]Product B Target[/TD]
[TD="class: xl63, width: 64"]Product A Actual[/TD]
[TD="class: xl63, width: 64"]Product B Actual[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]1-Jul[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]1-Aug[/TD]
[TD="class: xl65, align: right"]6[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]6[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]1-Sep[/TD]
[TD="class: xl65, align: right"]7[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]7[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]1-Oct[/TD]
[TD="class: xl65, align: right"]8[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]8[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]1-Nov[/TD]
[TD="class: xl65, align: right"]9[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65, align: right"]9[/TD]
[TD="class: xl65, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]1-Dec[/TD]
[TD="class: xl65, align: right"]10[/TD]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65, align: right"]10[/TD]
[TD="class: xl65, align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]


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...