Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I tried to google this but no luck. It is easy to add a pie chart when you have prcentace data but what if you just have a list of partially repeated data?

For simplicity imagine there is a table in Excel which represents all cars in a town. One of columns is 'color'. How is it possible to add a pie chart representing colors of cars without calculating percentage? And, it is important to mention that if comeone will add a pink or any new color car first time into the table, the pie chart should automaticaly have one more slice.

share|improve this question
add comment

1 Answer 1

If you have two columns:

Colour  Number
Red     3
Blue    5
Green   6
Purple  4
Black   10

Then create the pie from these it will work.

To add a new colour so it gets automatically inserted into the chart you'll need to insert a new line rather than just appending to the end.

Colour  Number
Red     3
Blue    5
Green   6
Purple  4
Pink    1     <-- new value inserted here.
Black   10
share|improve this answer
    
Beat me to it. No need for percentages - they're implicit in pie charts. –  variant Jul 28 '10 at 13:47
    
These things will will require additional calculations. What I have: Ford AAA111 Red / Nissan BBB222 Blue / Mini CCC333 Pink / Alfa-Romeo DDD444 Red / (sorry, website removes CRLFs) –  Usability victim Jul 28 '10 at 14:38
    
@Usability victim - Update your question with this extra information. –  ChrisF Jul 28 '10 at 15:16
    
ChrisF, what extra information do you need? –  Usability victim Jul 28 '10 at 16:56
    
@Usability victim - what you posted as a comment, that way we'll have your real data, properly formatted, to work from. –  ChrisF Jul 28 '10 at 17:19
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.