Stacked Bar for Target vs Actual + Projection?

[tekobayashi]

I am trying to make a bar chart that shows (1) the sales target in one bar and (2) a stacked bar that shows actual sales amount + sales projection (different colors).

Basically I have these (example):
Quarterly Target Sales: 10,000
Actual Sales (to date): 2,000
Projected Additional Sales (to end of quarter): 4,000

In one chart, I want a single bar that shows the Target Sales and a stacked bar that puts Actual Sales and Projected Additional Sales together, so that I can compare this with the Target Sales.

is this possible?

[Andy Pope]

http://peltiertech.com/WordPress/clu...mn-bar-charts/