Hi Alex!

This will do it.
I will treat your data as in cells A1:B13

Add a helper column next to column A: this becomes the new column B.
In B1 pu
=if(A1="A",1,if(A1="C",2,if(A1="D",3,if(A1="F",4,i f(A1="R",5)))))
(Simply converts your A,C,D,F,R,to 1,2,3,4,5 respectively)
Copy this down to B13.
Now plot columns B,C using the XY scatter graph.
Don't choose a graph with lines joining the points. It's easy to chang
the symbol for a point if you don't like Excel's default.

Al

--
Message posted from http://www.ExcelForum.com