Thread: Chart Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Max Max is offline
external usenet poster
 
Posts: 390
Default Chart Help

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