Hacking Excel, Part 1
Subject:   Better functionality over 180
Date:   2008-07-12 14:30:49
From:   Bob Wester
Nice solution! The chart works better from 0 till 100 if you change E2 till E5 into: 200; =((200/100)*F3)-2; =E2-SOM(E3:E4).I use this chart for a -50% till +50% and with the normal values in E I never can reach the -50% or +50%! Or in this example it is not possibel to set the needle on the 0 or 100!