Solved

MS Excel 2010 How to graph letters

Posted on 2013-01-15
3
348 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
  • 2
3 Comments
 
LVL 79

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DBF to ... Converter 5 49
Add a range in an Excel graph 5 36
NEED TO UPDATE DATA IN EXCEL 18 32
Export Data to Different .csv Files 26 64
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

864 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now