Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Creating 5 Charts from Pivot table

    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
    Attached Thumbnails Attached Thumbnails PivotTable.bmp  

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Can you attach a sample rather than an image? You can use dummy data, if it is sensitive.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •