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     www.energyefficientbuild.com.    Feb 16, 2013
user freyj said:(http://productforums.google.com/forum/#!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: http://goo.gl/G8FiZ

-----------------------------------------------------------------------------------------------
following is a solution to the problem