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?