Saturday, February 16, 2013

yogi_Count Reading Comprehension By Band And Chart the Results

                                          Google Spreadsheet   Post  #1030
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Feb 16, 2013
user freyj said:(!category-topic/docs/spreadsheets/how-do-i/desktop/UoGqc0N-J5U)
Chart a series of text or numeric scores
I am trying to find the p
ercentage of each unique text value (and sometimes a range of text values) and then graph the results. For example, how many students have a reading level of "G" in column F, how many students have a reading level of "H-J". Then, have a pie chart that graphs each scoring band (G, H-J, K-L, M-Q, etc.) by percentage. Here's a shortcut to my open doc:

following is a solution to the problem