pie chart grouping

[Guest]

hello

I have some data (exam marks) as follows

64.4
49.3
64.6
76.9
50.9
69.7
73.9
62.6
82.4
68.3
49.4
56.9
59.3
68.6
55.3
74.1
65.9
68.2
67.9
71.5
67.7
64.5
66.7
73.1
41.8
53.3


I want to produce a pie chart that shows marks:

1st = 70% and above,
2:1 = 60 - 69%
2:2 = 50 - 59%
3rd = 40 - 49%

Is there an easy way to do this.


shane

 

[Debra Dalgleish]

YOu can make a lookup table of the groups:

0 3rd
50 2:2
60 2:1
70 1st

With your table of marks starting in cell A1, enter the following
formula in cell B1:

=VLOOKUP(A1,$D$1:$E$4,2)
where D1:E4 is the lookup table.

Copy the formula down to the last row of data.

To count the marks in each group, enter this formula in cell F1:
=COUNTIF($B$1:$B$26,E1)
and copy down to F4

Select cells E1:F4, and use the Chart Wizard to create a pie chart.