Pie Charts
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 |
Pie Charts
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 |
All times are GMT +1. The time now is 08:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com