How do I mix column chart types?

[Ramesh Narasimhan]

I would like to create a column chart where each x-axis point (date) has 2
columns, one for forecast and one for actual, but I would like to subdivide
the "actual" bar into 3 separate sections. Any ideas?? I have tried
pivoting and such, but to no avail. Thanks.

[Jon Peltier]

It's all about arranging the data:

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

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

Ramesh Narasimhan wrote:

> I would like to create a column chart where each x-axis point (date) has 2
> columns, one for forecast and one for actual, but I would like to subdivide
> the "actual" bar into 3 separate sections. Any ideas?? I have tried
> pivoting and such, but to no avail. Thanks.