I have a pie chart based on summary data with detail in the text. I want to gather all the catagories which do not make up more than 2 percent of the total and call them "All Others" on the pie chart, but leave the detail as it is, thus avoiding that mess of labels which bunches up into a black blob. Would someone please give me some tips on how I would go about doing this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Chart Tricks
- Thread starter JerryLan
- Start date
While you have the "on change of" field highlighted, click on the topN button and choose an N that will exclude the smaller slices. Allow the "Include Others with the Name 'Others'" to stay checked. While this isn't a percentage approach to the issue, it might be close enough...
-LB
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question