Pie Chart Troubles

[lajutown]

I need to create a pie chart based on the total of the values in the cells, not 100% which is what it seems to be defaluting to - can that be done?

Example, I have two figures, 83 and 11. I need the chart to consist of two slices, one showing 83%, the other showing 11%.

Right now, my chart is showing 88% and 12%, assuming the end must be 100%.

Any thoughts? I scanned the charts forum but didn't see anything that was an obvious posting about this same issue.

Thanks!

[Greg M]

Hi there,

Do you want your pie to consist of an 83% slice, an 11% slice and a 6% "missing" slice?

Regards,

Greg M

[Andy Pope]

The pie chart recalculates the percentages based on the data in the chart rather than draws slices of fixed percentages.

If you want fixed percentages you will need to add another value to the chart data that is the remainder of 100%-sum(your values), as Greg mentioned.

This additional 'holding' slice can then be formatted with no border or fill.