Pie Chart from Single Percentage Cell

[AllanTheCowboy]

If I have a single percentage cell that I want to plot as a pie chart, is there any way I can get it to present a percentage properly. Because there's only one data point in the series, it presents it as 100% of the pie chart, so even when the data label reads 83%, it's actually 100% of the chart. I can make it display properly if I make a new data series with the second cell as 1 minus the first cell. However, I'm distributing this, and really trying to avoid having extra cells that people can accidentally mess up, or that will confuse them because they won't know what they are.

So, can I take a single data point that says 75%, and make it appear as 3/4 of a pie chart, without a second data point?

[sktneer]

I never deal with the charts but see if this is something you can work with.

Assuming your percentage cell is A1, then in another cell place a formula =1-A1, now select A1 and the formula cell and insert a pie chart and set the fill color of the undesired data point to no fill.

See in the attached file for details.