So you would like a clustered-stacked column chart? Excel doesn't do
this type of chart natively, but with a little clever arrangement of the
data you can make a stacked chart look the way you want. This page links
to a handful of examples:

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

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


Mark wrote:
I need 2 stacked columns side by side for each month.

Here is the data for October:
Forecast Credits 200
Forecast Cash 50
Actual Credits 220
Actual Cash 55
Total Forecast 250
Total Actual 275

One column is forecast; the other is actual.
I would then need a line plotted on the secondary axis for Total Actual.

Can it be done?