I have the data for sets 1, 2, and 3 - the goal is to derive the data for set 'T'.Įssentially, we'd like to say 'business A had 30% capture across 100 contracts, business B had 50% against 70 contracts, and business C had 40% against 500 contracts' the individual pie charts are of course simple enough (even I can do that one ) ), but I would like them all to feed into a pie chart which shows the average percentage across all contracts with the total of contracts. Total: percentage of capture across contracts.Company C: percentage of capture across contracts.

At this point, a blue dotted box will appear on the chart, showing where the slice is being dragged.3. Company B: percentage of capture across contracts Click the slice we want to pull out, press the left mouse button to drag the slice out from the center of the 3-D pie chart.Company A: percentage of capture across contracts.

These pie charts are part of a proposal for new business they measure incumbent capture across multiple contracts from different teaming partners. In short, i'm trying to find the right way to display a collection of pie charts.

I will try to explain as simply as I can so I don't muck it up. I'd like to learn, but at the moment I have an intense business problem to solve that I think (hope?) is straightforward enough that it could be answered easily. First off, be warned: I am a complete stats novice.

Create pie chart in excel percentages