Customer Feedback chart

[Pip]

I need to create a customer feedback chart. They have had to complete a
comment card by answering excellent, good, average, poor and bad for a series
of items. How can I input this data into excel and then show the results in a
pie chart?

 

[Jon Peltier]

The pie chart needs this data:

Excellent XXX
Good XXX
Average XXX
Poor XXX
Bad XXX

Select the data and use the Chart Wizard (chart-like button on the standard
toolbar, or use Insert menu > Chart) to create a pie chart.

If your data is like:

CUSTOMER RATING
Customer A Excellent
Customer B Average
Customer C Poor
Customer D Average
Customer E Good
etc.

you can get it into the required format using a pivot table (Data menu),
putting the Rating field into both the row and data areas of the pivot
table, or using formulas:

Put the ratings into a range, say E1:E5, then in F1 enter this formula:

=COUNTIF($B$1:$B$100,E1)

where B1:B100 is the range containing the ratings. Fill this formula down to
F5, and you have a table like that at the top of this reply.

- Jon