Thread: Can this Stacked Chart be Done ??

Hi,

Can anyone advise me if this stacked chart is possible and if so how do I achieve it.

Basically, I have the following set of data for Jan, Feb & Mar. Each month has Opened and Frozen calls with a series of days range

Opened 0-2 days 3-5 days 6-10 days 11-15 days 16-29 days 30+ days
Jan 10 3 8 2 3 2
Feb 6 6 6 6 6 6
Mar 2 10 2 10 11 10

Frozen 0-2 days 3-5 days 6-10 days 11-15 days 16-29 days 30+ days
Jan 4 6 2 3 9 8
Feb 7 7 4 4 11 9
Mar 6 4 3 1 7 6


What I’m trying to do is to chart each month in a stacked chart showing the days range with the Opened and Frozen stacked for each month and each days range. Please refer to attached picture Iin the zip which drew in paint


Any help would be most appreciated

Excel version 2003


Many thanks


Rob

Take a look here, looks like someway to it?

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