The scroller must be connected to some cell. Let's say this is A1.
Then, in some empty cell, say B1, enter =A1*0.5. Use B1 wherever you
were using A1.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hello,

I have the dynamic charting, now working the way I want it. But, I want the
values to increment by 0.5 using the scroller. It doesn't seem to accept
this, how can I do this.

regards