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

On Aug 6, 3:57*pm, valerie wrote:
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