I've got two scrollbars on my graph that are used to control values for the X and Y axis and they work fine until they get to negative values. The value goes from 0 to 655351? I've made sure that the cell in question for the value is of type number, etc. Any ideas?
Thanks for the help EG but I figured it out. Basically scrollbars cannot output negatives so I used a hidden cell with the basic formula of =20-A1. that then gave me a range on my scroll bar from -20 to 20.