|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 5th, 2005, 02:27 PM
|
|||
|
|||
X Y with Letter grade Labels
HI,
I have a graph where I ask departments to rate their talent pool from 1 - 10. Then I ask them to grade their department from A+ to F. So for an xy chart x is the grade and y is the talent pool number. How do I get the scale to show A+ down to F instead of numbers? Any help would be appreciated. Thanks. 
|
|
#2
July 5th, 2005, 02:34 PM
|
|||
|
|||
|
An XY chart is used to plot numbers not categories. Use a Line chart
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... HI, I have a graph where I ask departments to rate their talent pool from 1 - 10. Then I ask them to grade their department from A+ to F. So for an xy chart x is the grade and y is the talent pool number. How do I get the scale to show A+ down to F instead of numbers? Any help would be appreciated. Thanks.
|
|
#3
July 5th, 2005, 02:51 PM
|
|||
|
|||
|
Hi Bernard,
I do realize that. I want to assign the Talent Pool from 1-10. The letter grades would be 1 - 13. 1 - A+ down to 13=F. The graph works. I just wanted to know how to get the scale to show Letters rather than the numbers. I was hoping there was a better way than to hide the scale and draw the letters. Thanks. Ken "Bernard Liengme" wrote: An XY chart is used to plot numbers not categories. Use a Line chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... HI, I have a graph where I ask departments to rate their talent pool from 1 - 10. Then I ask them to grade their department from A+ to F. So for an xy chart x is the grade and y is the talent pool number. How do I get the scale to show A+ down to F instead of numbers? Any help would be appreciated. Thanks.
|
|
#4
July 5th, 2005, 03:15 PM
|
|||
|
|||
|
Rob Bovey's XY Chart Labeler (a free add-in) will let you do this. You
can download it from his site: http://www.appspro.com/utiliti*es/Labeler.asp -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... Hi Bernard, I do realize that. I want to assign the Talent Pool from 1-10. The letter grades would be 1 - 13. 1 - A+ down to 13=F. The graph works. I just wanted to know how to get the scale to show Letters rather than the numbers. I was hoping there was a better way than to hide the scale and draw the letters. Thanks. Ken "Bernard Liengme" wrote: An XY chart is used to plot numbers not categories. Use a Line chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... HI, I have a graph where I ask departments to rate their talent pool from 1 - 10. Then I ask them to grade their department from A+ to F. So for an xy chart x is the grade and y is the talent pool number. How do I get the scale to show A+ down to F instead of numbers? Any help would be appreciated. Thanks.
|
|
#5
July 5th, 2005, 03:16 PM
|
|||
|
|||
|
Did I get that right: http://www.appspro.com/Utilities/ChartLabeler.htm
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... Hi Bernard, I do realize that. I want to assign the Talent Pool from 1-10. The letter grades would be 1 - 13. 1 - A+ down to 13=F. The graph works. I just wanted to know how to get the scale to show Letters rather than the numbers. I was hoping there was a better way than to hide the scale and draw the letters. Thanks. Ken "Bernard Liengme" wrote: An XY chart is used to plot numbers not categories. Use a Line chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... HI, I have a graph where I ask departments to rate their talent pool from 1 - 10. Then I ask them to grade their department from A+ to F. So for an xy chart x is the grade and y is the talent pool number. How do I get the scale to show A+ down to F instead of numbers? Any help would be appreciated. Thanks.
|
|
#6
July 5th, 2005, 03:39 PM
|
|||
|
|||
|
THanks!
"Bernard Liengme" wrote: Did I get that right: http://www.appspro.com/Utilities/ChartLabeler.htm -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... Hi Bernard, I do realize that. I want to assign the Talent Pool from 1-10. The letter grades would be 1 - 13. 1 - A+ down to 13=F. The graph works. I just wanted to know how to get the scale to show Letters rather than the numbers. I was hoping there was a better way than to hide the scale and draw the letters. Thanks. Ken "Bernard Liengme" wrote: An XY chart is used to plot numbers not categories. Use a Line chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "KenRamoska" wrote in message ... HI, I have a graph where I ask departments to rate their talent pool from 1 - 10. Then I ask them to grade their department from A+ to F. So for an xy chart x is the grade and y is the talent pool number. How do I get the scale to show A+ down to F instead of numbers? Any help would be appreciated. Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert to Symbols | Omar Menjivar | General Discussion | 7 | June 27th, 2005 07:32 PM |
| How can I assign a number value to a letter grade in Excel? | BlackBond | Worksheet Functions | 2 | April 5th, 2005 08:20 PM |
| Student grades, converting numerical to letter grade | Alan in Canterbury | General Discussion | 1 | August 25th, 2004 10:56 AM |
| Letter grade display | Jer53621 | Worksheet Functions | 2 | March 31st, 2004 01:16 AM |
| Grade Book project | Emma | Worksheet Functions | 3 | October 24th, 2003 04:29 PM |
Linear Mode
