Question: 4. For each hospital, in the spreadsheet - create a pie chart of the rolled up Functional Centres (to level 3) The pie charts should

4. For each hospital, in the spreadsheet - create a pie chart of the "rolled up" Functional Centres (to level 3) The pie charts should include total costs for the listed functional centres at level 3. Exception: so that the pie charts have fewer 'slices', please roll the therapies only (function centre name begins with TH) to level 2. Refer to the MIS lesson (Topic 28) for details on functional centre levels and roll ups. % should be based on Total cost (not average). Be sure the data labels on the pie charts are formatted to show percentage. Let the instructor know if you are struggling to configure them. (HINT: Both hospitals will have fewer functional centres than they started with when the roll-up is complete. The Hamilton pie chart will have 13 slices. The Mount Sinai pie charts will have 10 slices.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!