Stacked and single column in same chart?

[Einstine]

How can I do a chart with a stacked column beside a single column? When I build a stacked column chart, any new source data I add
wants to put it in the same stacked column.

 

[Jon Peltier]

Use one of the links on this page. You need to set up the data so the
single column is in a stacking position with no other columns of data.

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

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