Simple? pie chart

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

 

[Debra Dalgleish]

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.

 

[darius]

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.

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

 

[Debra Dalgleish]

You could position the chart over the table, and the table won't be printed.