Solved

MS Excel 2010 How to graph letters

Posted on 2013-01-15
3
360 Views
Last Modified: 2013-01-17
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
Comment
Question by:shogun5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 82

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 38781089
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
 

Author Comment

by:shogun5
ID: 38781092
How would I do this? In a vlookup table? Can you provide an example on the sample spreadsheet provided?  Thanks!
0
 

Author Closing Comment

by:shogun5
ID: 38786872
Okay....used a vlookup to work this out.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question