Can I use side by side colums and stacked columns in same graph?

[Guest]

I have a completed graph that shows side by side columns and a line, but I
would like to add a stacked column to the graph without losing the other side
by side columns.

 

[Jon Peltier]

Debbie -

You need a stacked-clustered column chart. This page has links that show how to
accomplish such a chart. Most likely you'll have to rearrange the data and make a
new chart.

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

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