Showing a percentage of a percentage in pie chart

**jimbob76** · 06-17-2009, 09:05 AM

Hi, I have 2 lots of data that I'm trying to show simultaniously in a pie chart. Firstly I have the work done by my team split in to various different job codes. I then also need to show (on the same chart) the percentage of these individual jobs that have been outsourced. Please have a look at the example data below and let me know if this is possible:

Job Code, % of workload, % of this job that is outsourced

1, 30, 10
2, 25, 15
3, 45, 0

So the pie chart should be initially split in to 3 to show the jobs as a percentage of our total workload. I then need to separate these 3 slices in to 2, showing the percentage of them completed in house and those outsourced. Hope this makes some sense.

Thanks
Jamie

**10g106** · 06-17-2009, 09:32 AM

Hi,
where did the rest of the % go if you want to find the percentage of outsourced and inhouse?
you sample shows:

Job Code % of workload % of this job that is outsourced
1 30 10
2 25 15
3 45 0

to get the % of outsourced out of the % workload, we need to get the remaining values of the % outsourced in the job code,
say
job code 1 at 30% workload and 10% outsourced, remaining 90% inhouse, to graph, 10%/30% labeled as outsourced, then 90%/30%, inhouse

i hope im making sense

**starryknight64** · 06-17-2009, 09:35 AM

There's a few ways you could do this, and this all depends on what exactly you want to see done:

You could have separate pie charts: one for the whole % of workload, one for the 30% job (showing that 33%--that is: 10%/30%--of that job was outsourced), one for the 25% job (showing that 60%--that is: 15%/25%--of that job was outsourced), etc...
Or you could still have that one pie chart just do a little math and use some color similarities to show that the 30% job (we'll call it dark blue) had 10% of its work outsourced and that comes to 3% (that's 10% of 30) of all the work being done (the 3% slice of the pie is in light blue). While the 25% job (dark green) had 15% of its work outsourced which comes out to 3.75% (that's 15% of 25) of all the work being done (the 3.75% slice of the pie is in light green). etc...

I hope this helps!