Database + Generating Y Values

[omairsyed]

Hi, I'm trying to find a way to correlate X values to already defined Y values. For example, I would like to set each X value between 1-10 to match particular Y values (for example, 1=1000, 2=2000...etc). So if i want to create a line graph where on the bottom (X-Axis) I have categories such as Experience, Education, Reliability, etc. So if i put in a 5 for Experience I want the Y value for Experience to come up as 5000 without having to put 5000, I just want to be able to insert 5 as the X and 5000 comes up as the Y. I'm guessing you do this by using the database functions, but I cant manage to get it to work, thanks for the help!

[shg]

Welcome to the forum.

That's pretty cryptic.