[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

MS Excel 2010 How to graph letters

Dear Experts,

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.

Attachments:
(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.

Thanks again!
LSS-Template.xlsx
graph-example-blot.png
graph-example-line.png
assessment-marks.docx
0
shogun5
Asked:
shogun5
  • 2
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
When one is marking a test you get a value i.e. 20/25 = 80% which is then given a letter grading.  Usually and A is 80% or higher B is 70-79%, C is 60% - 69%, D 50-59% and so forth. So what you have to do is change the grading to a value. An incomplete (grade of I) can be ignored. You can then do your graphing.
0
 
shogun5Author Commented:
How would I do this? In a vlookup table? Can you provide an example on the sample spreadsheet provided?  Thanks!
0
 
shogun5Author Commented:
Okay....used a vlookup to work this out.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now