Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Excel 2010 How to graph letters

Posted on 2013-01-15
3
Medium Priority
?
369 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 84

Accepted Solution

by:
David Johnson, CD, MVP earned 1500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

879 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