Ask questions via twitter! Message any question to @answers on twitter. We'll publish the question and send you a reply each time there's a new answer.
Next Question

Question

cromely cromely
 

Mahalo is adding a tip to all questions that don't offer a tip.
 M¢25  Funded By Mahalo ? |  August 09, 2009 06:24 AM

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.
Interesting Question?  Yes (0)   No (0)   
Email to a friend | RSS
 
 

 
   No Best Answer Selected
 
 


Answers (1)

Sort By
travisvt travisvt
 
August 10, 2009 01:01 AM
Try adding a fixed minimum value for your chart. Details in the attached link.
Source(s):
http://blogs.techrepublic.com.com/msoffice/?p=371


Helpful Answer?  (0)   (0)    Tip travisvt for this answer
Permalink | Report
   Reply  
 
 
mysterygir... mysterygir...
 
August 24, 2009 08:13 AM
Bump to voting. (^_^)V

Report
 
 

Answer this Question


Related Questions

View All Software Questions

Ask a Question


140 characters left
Top of Page
Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time
  • buddawiggi
    buddawiggi
    2nd Degree Black Belt
    28397 Points
    M$815.66 Earned
  • cfinke
    cfinke
    2nd Degree Black Belt
    26457 Points
    M$29.75 Earned
  • thisjustme
    thisjustme
    Green Belt
    1132 Points
    M$76.05 Earned
   See All
 

Most Popular Tags

mahalo(1719)
twitter(965)
music(489)
iphone(478)
google(375)
food(332)
online(324)
internet(309)
beer(282)
money(278)
movies(274)
apple(256)
facebook(246)
answers(235)
aotd(235)
health(226)
video(219)
free(216)
dog(209)
windows(201)
   See All
 

Categories

Welcome New Members


 
 
Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More

 
 

Please log in to use this function.

Answers Home | Ask a Question | Earn Points | How Tips Work | Widget