Pie Chart from Excel Data

smarie123

New Member
Joined
Aug 18, 2014
Messages
36
I am having a seriously difficult time getting this information into a pie chart that my boss wants to see.
Here's what I'm looking for:
If I have a table setup with Divisions, % of Employees billable, & % of employees non billable in columns.The in the rows beneath I have each division with the corresponding percentages.
I have already made a bar graph with the percentages per division. Now I am trying to make a pie graph with the company total (so I totaled each division an got the percentage for both types of employee for the entire company.)o t needs to be basically two parts of the pi char - billable and non billable - then I want the non-billable section to break out and show me which percentage in each division makes up the total company non billable portion. I hope that makes sense!!!

Thanks!!
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,109,448
Messages
5,528,804
Members
409,837
Latest member
karnasrinivas
Top