Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 have an excel sheet that has these kind of values in one of the columns:

Very Good
Very Good
Very Good


I am trying to insert a pie chart which shows how many times very good is repeated and so on. How can I do this?


share|improve this question
up vote 1 down vote accepted

A pivot table would let you this quickly and without formulas.

  • Select your table (in your example, just this one column), including the header name
  • Click "Insert PivotTable"
  • Click OK.

An empty PivotTable is created. On the field list on the right, you see one field which has your column's name.

  • Drag and drop the field to the Row Labels section below.
  • Drag it once more to the Values section below. It should show "Count of column name". (If not, you must set it to count).

You should now have a table with the number of occurences for each item.

  • Insert Chart.
share|improve this answer
Thank you very much, works perfectly!! – iamserious Jan 25 '11 at 16:56
I Wanted to vote up your answer as well but I dont have enough points sorry! – iamserious Jan 25 '11 at 16:56

Your Answer


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.