Hi Guys,
A lengthy question i'll throw out there.

What I've got is 20 numbers each which have a reference range that applies
to them individually (i.e. 20 numbers each with their own range) I want these
all graphed on one chart and currently I work the numbers to find the ratio
from the norm that it is.
For example the range for a number is 1 - 20. What i want, so i can graph it
decently is that 1 is equal to -1, 20 is equal to +1 and then 10.5(the mid
value) is equal to 0.

Most importantly this formula to change the numbers is that it will work for
any number in any range.

Thank you, Rainer

Currently i have a formula which makes 1=-1, and 20=+1 but then the middle
value does not work properly. I think i'm going about this in the wrong way.
Anyone have any shortcuts to what i want?