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

ColumName
``````````
Very Good
Bad
Good
Very Good
Very Good
Good

etc..

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?

thanks

share|improve this question

1 Answer 1

up vote 0 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

 
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.