creating multiple pie charts

[jartzh]

I have a need to create a pie chart for every crew's injuries.
Ex:
crew type
100 arm
100 arm
100 arm
100 eye
100 leg
100 leg
200 arm
200 leg
200 leg
200 leg
I would need a pie chart showing only crew 100 and a different chart showing crew 200. I can do this manually by selecting rows but I have to do a lot of these and I was hoping I could have excel split them up and create the charts.

Possible?

[Andy Pope]

You will have to summarize the data with formula or pivot table.

[jartzh]

Thanks Andy,

I did get the data in form:
100 arm 3
100 eye 3
100 leg 2
200 arm 2
200 leg 3

But I dont know how to get pie charts out of it without manually selecting :
arm 3
eye 3
leg 2
then inserting a pie chart and editing the title to "crew 100".
Then do the same for crew 200...

[Andy Pope]

You will either have to do it manually or write code.
This is no short cut to mass production of charts.