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
-----------------------------------------------------------------------------------------------
following is a solution to the problem
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
This comment has been removed by the author.
ReplyDeleteThat's almost it! How would you graph the bands containing a range of letters (one bar for the total number that scored a D, E, or F?
ReplyDeleteHi Joel:
ReplyDeleteI have added Sheet2 where I have combined counts for Bands D,E, and F, and then charted for bands DEF,G,H,I,J, and K.
Please check it out how it works for you.
Make It A Great One.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com