Just created a Pivot table in Excel – with the following results
HTML Code:
Count of Response Rate Calendar Days Calendar Graph
Service Same Day Response Within 2 Working Days 3 to 5 Working Days Over 5 Working Days Grand Total
Nutrition & Dietetics 12772 200 161 283 13416
Occupational Therapy 10781 632 290 282 11985
Physiotherapy 30676 876 849 475 32876
Podiatry 154 1 2 157
Speech & Language Therapy 4046 71 26 46 4189
Grand Total 58429 1780 1328 1086 62623
What I need to do is created 5 different Pie Charts for each Service (Nutrition & Dietetics, Occupational Therapy, Physiotherapy, Podiatry, Speech & Language Therapy) split by Calendar Graph.
For Example, Pie chart to show percentage of Nutrition & Dietetics split by Calendar Graph (Same Day Response, Within 2 Working Days, 3 to 5 Working Days and Over 5 Working Days)
I’ve tried it but each time I try to pick a specific service, the pivot table changes to show that specific service activity… I don’t want it to do that… I want it to show all Service, and create 5 individual graphs for each service…
Hope it makes sense…
Thanks in advance
dBforums
>
Creating 5 Charts from Pivot table
10-25-07, 06:51
Linear Mode
