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
|
|||
|
|||
Letters = Numbers
I am creating a spreadsheet that will contain cells with the following: A, B, C, D, E I need these letters to equal 5, 4, 3, 2, 1 So that when I create charts I can plot using the letters (gradescale). so I could get data like a 3000 fence made of grade "A" materials will last say 5 years. and that no matter what I plot the letters A,B,C,D,E will always equal 5,4,3,2,1. How can this be done? Please help. Thanks -- oberon.black ------------------------------------------------------------------------ oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732 View this thread: http://www.excelforum.com/showthread...hreadid=484119 |
#2
|
|||
|
|||
Letters = Numbers
Is it not allowed to have one column for letter rating and another (hidden) for
numerical equivalent? Excel just isn't going to plot the text as anything other than 0, but you can write simple lookup formulas to convert the letters to numbers in another column, and those numbers will plot like numbers. You can put a fake axis onto the chart, so it looks like the letters are aligned along the value axis: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ oberon.black wrote: I am creating a spreadsheet that will contain cells with the following: A, B, C, D, E I need these letters to equal 5, 4, 3, 2, 1 So that when I create charts I can plot using the letters (gradescale). so I could get data like a 3000 fence made of grade "A" materials will last say 5 years. and that no matter what I plot the letters A,B,C,D,E will always equal 5,4,3,2,1. How can this be done? Please help. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Sort" a combination of letters and numbers e.g. 20, 21a,200, 105c | Crazy Lady | Setting Up & Running Reports | 7 | October 5th, 2005 05:40 PM |
format numbers to letters | mhmaid | New Users | 1 | August 12th, 2005 01:49 AM |
Serial Numbers for Letters | RFoehl | Page Layout | 0 | March 29th, 2005 03:49 PM |
Separating letters and numbers from same column? | Manfred | General Discussion | 3 | September 16th, 2004 07:47 AM |
Column Labels switched from letters to numbers | Melanie | Setting up and Configuration | 1 | October 10th, 2003 12:44 AM |