Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Excel 2010 How to graph letters

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

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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
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…

721 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