Clustered and Stacked Column Chart
 

Is it possible in excel 2002 to do a Clustered Column chart but stacked.
So the columns are stacked and clustered
Jan - Apr
CostsA1 5 dark blue
CostsA2 0.5 light blue
CostsB1 10 dark green
CostsB2 0.5 light green
CostsA darkblue with the light blue on the top of the stack - in january
CostsB darkgreen with light green on top of the stack - in january

I can do it with out the separating out the top 0.5 Lightcolour but how do I
do showing the top lightcolour

Many thanks
Cassie

Clustered and Stacked Column Chart
 

I've written a tutorial showing how to rearrange your data to facilitate
this chart type:

http://peltiertech.com/WordPress/clu...column-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Cassie" wrote in message
...
Is it possible in excel 2002 to do a Clustered Column chart but stacked.
So the columns are stacked and clustered
Jan - Apr
CostsA1 5 dark blue
CostsA2 0.5 light blue
CostsB1 10 dark green
CostsB2 0.5 light green
CostsA darkblue with the light blue on the top of the stack - in january
CostsB darkgreen with light green on top of the stack - in january

I can do it with out the separating out the top 0.5 Lightcolour but how do
I
do showing the top lightcolour

Many thanks
Cassie