Thread: scatter plot, get units of measure from a worksheet

Hello,

I am trying to create a scatter plot graph to show information exchanges that occur within an information system. The way that I am going about this, is to create a graph with the x-axis representing the "TO" of the info exchange, and the y-axis representing the "FROM" of the exchange. However, the units on the x and y axes are not numerical, they are task codes. I have transferred the task codes to a sheet in the same workbook, figuring that there had to be some way that I could specify the units on the x and y axes from a worksheet that is in the same workbook, but I have not been able to find any literature that specifies how to do this, or even allow text to be the units of measure on either of the axes of a scatter plot graph.
PLEASE HELP!
Thanks~ Jh

I expect the best way to get "text" onto a scatter plot is to create your own method of "converting" those text values to numbers. 1st idea that comes to my mind is to make a lookup table, maybe like so:

taskid,a,b,c,d,e,...
value,1,2,3,4,5,...

then use a lookup function (HLOOKUP, LOOKUP, MATCH, VLOOKUP) to determine what "value" each task id gets. Then plot those values.