Chart Help

[Guest]

I have a list of providers with different categories that they score on;
scores varies for eac Category.
Eg Cat1 score are 0, 2 , 4
Cat2 scores are 0, 5, 10
Cat3 scores are 0, 1

How can I draw a Pie or bar graph that will show each category in one
section of the graph on the X axis, scores are in the Y axis, showing how
many providers in each score/category?


Prov Cat1 Cat2 Cat3
0 0 0 0
1 0 5 1
2 2 10 1
3 4 5 1
4 0 0 1
5 2 5 1


Thanks

 

[Guest]

You need a sumary row at the bottom of the table. the use as the x-axis the
1st row with the Cat1 Cat2 and Cat3 as the x-axis lables.

I'm not sure from you description if the summary row should contain either
formula 1 or formula 2

=sum(A2:A6) which add all the number in cat1

or if you just want a count
=countif(A2:A6,">0")