Display a Pie Chart from a Fraction

In I10, =1-I9

Then format the smaller slice to have no fill. Rotate 120 degrees to look like Pac-Man.

You need an entry for each slice that you want. To get "5" slices of a pie, you need 5 entries. If you need 6 slices (which is what it sounds like you want), then you need 6 entries. As shg has suggested, the 6th slice can be 1-sum(previous 5 slices) to force the total to be 1.

Please Login or Register  to view this content.

will give you 6 equal portions of a pie.

Would be so much easier though if I could just have Excel generate the correct pie chart based on the fraction alone.

I'm sure it can be done, but you, the programmer, need to tell Excel how to take "one fraction" and separate it out into its parts. The flow of logic that I see you describing:

1) Computations that compute individual fractions of a whole.
2) These fractions are combined into a single fraction of the whole
3) You want Excel to take that single fraction and separate it back out into multiple fractions (same fractions as 1 or different?) and display in a pie chart.

If the result of step 3 should be the same fractions as computed in step 1, then simply bypass step 2 and base the pie chart on the results of step 1. If the result of step 3 is a different set of fractions, then add formulas in Excel to compute these fractions from the result of step 2 and base your pie chart on those.