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!
Bookmarks