Article:  |
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! | ||
Women in Technology
Hear us Roar
