Indeed odd in Excel 2003 that for you the chart updates with the Forms
control but not for me (until mouse is released).

In Excel 2007 it sounds like for you it works but only after a delay. Maybe
you have a complex graph and/or a lot of calculations (various reports say
Charts in Excel 2007 are significantly slower to update). I made only the
minimum necessary to test, works almost immediately for me.

If interested I can forward my test workbook.

On Excel 2007 (i don't know how to see which version, but I believe
its the latest update),

Excel Options, Resources, About

Regards,
Peter T


"Robert Avery" wrote in message
...
Thats strange. For me, on Excel 2003 (11.6560.6568) SP2, using EITHER
the Forms or embedded ActiveX controls updates the graph instantly
while the mouse button without releasing the mouse. I wonder why this
is different from your experience.

On Excel 2007 (i don't know how to see which version, but I believe
its the latest update), using Forms control does NOT update the chart
at all until after mouse release, whereas the embedded ActiveX control
updates while mouse is still held, but only after a short (1 second)
pause over a particular value in the scrollbar -- if I keep on moving
the scrollbar, the chart won't update at all until i stop moving.
Therefore, even though it will update while mouse is still down, its
on such a lag that its effectively not real-time anymore, unlike in
Excel 2003.