Stuck on this one. Not sure how to graph letters.
The attached spreadsheet lists three sheets (one per grade level). What I am trying to do is to create a graph (either line or scatter) based on the average Quarter Assessment for the class. For example the target assessment grade for 1st Grade Quarter 1 is F (depicted on the graph with a color line) (see attached word document for targets).
I just need to have a graph on the same sheet as the grade level assessment (to the right of the data values) so teachers can get an idea how their students are doing and how close to the target they are. A scatter chart may be best for this.
Anyway, this is probably an easy fix but I am a bit new to creating graphs and need a bit of help.
(1) sample excel spreadsheet
(2) sample chart - scatter
(3) sample chart - line
(4) targets - word doc.
Any assistance you can provide would be most helpful. If you have provide assistance with one chart I can manage the rest.