Simple? pie chart

  • Thread starter Thread starter darius
  • Start date Start date
D

darius

Hi

I have data like this

customer food service
----------------------------
john excellent good
mary excellent excellent
david fair fair
diane good good
jim poor fair

I want to create one pie chart for food (and one for service) that hows
what % of customer rated the food (service, resp.) as
excellent/good/fair/poor. Seems pretty simple, but naturally it's not.
 
Set up a table with the ratings in the firs column, and the categories
across the top:

Food Service
poor
fair
good
excellent

In the first cell under food (G2 in this example), enter a formula that
counts the entries in the ratings table (A1:C6) --
=COUNTIF(B$2:B$6,$F2)
copy the formula down to G6, and across to column H.

Select cells F1 to G6, and use the Chart Wizard to create a pie chart.
Then, select F1:F6 and H1:H6, and create the second pie chart.
 
Set up a table with the ratings in the firs column, and the
categories across the top:

Food Service
poor
fair
good
excellent

In the first cell under food (G2 in this example), enter a formula
that counts the entries in the ratings table (A1:C6) --
=COUNTIF(B$2:B$6,$F2)
copy the formula down to G6, and across to column H.

Select cells F1 to G6, and use the Chart Wizard to create a pie
chart. Then, select F1:F6 and H1:H6, and create the second pie
chart.
Click to expand...

Thanks. That's what I ended up doing. Btw, how do I "hide" this table,
from the printout at least (I don't want to have to exclude it by
selection).
 
You could position the chart over the table, and the table won't be printed.
 
Back
Top