How do I mix column chart types?
 

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.

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.