Chart is a Stacked/Cluster possible?

[kenreavy]

Hi

Is it possible to create a clustered stacked chart?

I want to show projects to be completed by four people over the year in hours. Each person has around 30 projects over the year so for one person I would show weeks along the bottom y axis and time in hours on the x axis. The projects would then be stacked showing total hours each week over the year.

Now I want to show all four people on one chart maybe clustered. Instead of the legend showing project name I could use numbers and a seperate key to show project names.

I hope that makes sense.

Thanks

 

[pgc01]

Hi kenreavy

Jon Peltier has a very good page on how to create a Clustered-Stacked Column Charts:

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

Hope this helps
PGC