2 years, 9 months ago
In Excel 2007, how do you make it automatically combine values under 2% for a pie chart?
I'm working on some pie charts that draw from 100+ lines of data, most under 2% of the total. How do I make Excel combine those small amounts into one "other" category. I'm pretty sure I could do this in Excel 03, but can't find the feature in the new version.
Excel offers the option to explode those small data slices into another chart element, but I don't want to explode it. I'm okay with just putting it into one slice on its own without showing additional detail.
Excel offers the option to explode those small data slices into another chart element, but I don't want to explode it. I'm okay with just putting it into one slice on its own without showing additional detail.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$1 Answer
Try adding a fixed minimum value for your chart. Details in the attached link.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$
Bump to voting. (^_^)V