I need a pie chart to show quarterly data for 5 different departments.
Each quarter will display in it's own pie chart. Each of the 4
quarterly pie charts will be sized proportionately to the year end
total. A fifth pie chart will display the TTL data for each
department. Is this at all possible? Is there a better way to show
such data?

Qtr 1 Qtr 2 Qtr 3 Qtr 4 TTL
Dept 1 10 30 20 15 75
Dept 2 15 25 25 20 85
Dept 3 20 20 15 30 85
Dept 4 25 15 8 30 78
Dept 5 30 10 19 35 94
100 100 87 130 417

Thank you in advance!

V