| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ratios in a range
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
Threaded Mode
