Pie Charts

[valerie]

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

 

[valerie]

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

I have found a solution. Thank you.

V