Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .