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 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
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

You must log in to answer this question.

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