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?


1 Answer 1


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.
  • I Wanted to vote up your answer as well but I dont have enough points sorry!
    – iamserious
    Jan 25, 2011 at 16:56

You must log in to answer this question.

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