Excel Graph Help

E

Ellesse

Hey gurus, a little help if you please...

basically im working on a school project, and i need to create a lin
graph containing stats of performance... the problem is, the data
need to make the graph from are Letters, and im wondering if there is
way to create a graph with a function that it recognises that eg: W =
D = 1 and L = 0 and plots the points accordingly, whether it be throug
use of Macros or otherwise.


Any help would be greatly received

regards

elless
 
B

Bernard Liengme

This will work for you: =LOOKUP(A24,{"D","L","W"},{1,0,3})
If you want more values, be use the lookup-vector (D,L,W..) is in ascending
order

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text to number graph 4
Making graphs from updates... 2
saving ppt file with animation- excel graph animated by series 2
i need to create a pie graph 1
Multiple Line Graphs 5
Creating Graphs + VBA 1
Excel PMT Function Help 2
Need help with using a bar graph in a report 4

Top