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!!
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!!