Two columns one stacked
 

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.

Two columns one stacked
 

See the second example at
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"irondoor17" wrote in message
...
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.

Two columns one stacked
 

Try these links:

http://peltiertech.com/Excel/ChartsH...sterStack.html

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"irondoor17" wrote in message
...
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.