Two columns one stacked

[irondoor17]

I am trying to create a chart that has three pieces of data (one objective
and two actuals) and have them combined into two columns for specific areas.
I'd like the objective to be one color and the actuals to be a stack of the
two sets of actuals to show the detail between the two. I have been
unsuccessful in creating such a chart. I'm not sure if this is even possible.
I'm using Excel 2003.

Thank you.

 

[Bernard Liengme]

See the second example at
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm
best wishes

 

[Jon Peltier]

Try these links:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

The first link in particular shows an example of clustered columns with a
single column next to stacked columns.

- Jon