I am an elementary school teacher.
Our students' reading progress is tracked by Fountas & Pinnell book levels. These levels proceed from A (easiest) to Z (most challenging).
I am trying to create a way of displaying student progress (e.g. comparing 25 students in one class) using a graph that could display the students' book levels.
I would like to use a bar graph that would show a bar for each student extending to the letter representing their book level. For example, I would like student names on a y axis and the a to z book levels on the x axis.
I am encountering difficulty because the letters are not numbers and I am interested in finding a way to have Excel create a alphabet based scale rather than number based scale.
I tried looking at Excel help and did a bunch of googling with no success, so I would be very appreciative of any help!
Our students' reading progress is tracked by Fountas & Pinnell book levels. These levels proceed from A (easiest) to Z (most challenging).
I am trying to create a way of displaying student progress (e.g. comparing 25 students in one class) using a graph that could display the students' book levels.
I would like to use a bar graph that would show a bar for each student extending to the letter representing their book level. For example, I would like student names on a y axis and the a to z book levels on the x axis.
I am encountering difficulty because the letters are not numbers and I am interested in finding a way to have Excel create a alphabet based scale rather than number based scale.
I tried looking at Excel help and did a bunch of googling with no success, so I would be very appreciative of any help!