Combination chart
 

I currently have two simple charts that I would like to combine:

a) The first is a stacked column chart that measures the severity of up to
21 different events on a 1 to 4 scale once per month. For example, the column
for March might have 1 severity 4 occurrence, 3 severity 3 occurrences, 5
severity 2 occurrences and 10 severity 1 occurrences against Event type A and
6,11, 9, 2 (respectively) against event type B etc. Each severity level has
a specific colour.

b) The second is a clustered column chart that shows the total number of
events by event type clustered into groups of 3 months. For example, Event
type A might show 19 events in March, 12 in February and 25 in January.

What I would like to do is combine these into a single chart so that each of
the 21 event types (A, B etc.) shows a 3 month history broken down by the 4
severity levels.

I realise that doing this sort of thing is usually dependant upon getting
the data arranged in a specific way, but I haven't been able to work it out
so any help would be appreciated.

Hope this makes some kind of sense!

TIA

Dave

Combination chart
 

Here's a tutorial about stacked-clustered charts:

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

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Risky Dave" wrote in message
...
I currently have two simple charts that I would like to combine:

a) The first is a stacked column chart that measures the severity of up to
21 different events on a 1 to 4 scale once per month. For example, the
column
for March might have 1 severity 4 occurrence, 3 severity 3 occurrences, 5
severity 2 occurrences and 10 severity 1 occurrences against Event type A
and
6,11, 9, 2 (respectively) against event type B etc. Each severity level
has
a specific colour.

b) The second is a clustered column chart that shows the total number of
events by event type clustered into groups of 3 months. For example, Event
type A might show 19 events in March, 12 in February and 25 in January.

What I would like to do is combine these into a single chart so that each
of
the 21 event types (A, B etc.) shows a 3 month history broken down by the
4
severity levels.

I realise that doing this sort of thing is usually dependant upon getting
the data arranged in a specific way, but I haven't been able to work it
out
so any help would be appreciated.

Hope this makes some kind of sense!

TIA

Dave

Combination chart
 

Excel 2007
PivotTable, PivotChart does it all,
automatically:
http://www.mediafire.com/file/mmdk1lj0laj/05_02_09.xlsx

Combination chart
 

How does a pivot chart combine clustered and stacked columns?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Herbert Seidenberg" wrote in message
...
Excel 2007
PivotTable, PivotChart does it all,
automatically:
http://www.mediafire.com/file/mmdk1lj0laj/05_02_09.xlsx