I can't replicate your problem, at least not with an embedded ActiveX
Scrollbar, linked cell changes source data and chart updates without
releasing mouse.

With a forms scrollbar behaviour is as you say, linked cell and source
values change but the chart only updates after releasing the mouse.

For me, behaviour with ActiveX and Forms scrollbars appears the same in
Excel 2007 and earlier versions.

Regards,
Peter T

"Robert Avery" wrote in message
...
I just started using Excel 2007 (on a separate machine, of course, in
case it is a disaster), and I am having problems with charts.

In Excel 2003, it was possible to use an embedded scrollbar which is
linked to a cell which changes the data underlying a chart. By
default in Excel 2003, under automatic calculation the Chart would not
refresh itself to display the updated data so long as you are still
holding the mouse button down (like when you are dragging the
scrollbar around, wishing to see updates in real-time). But you could
fix this by putting a formula that depends on the linked cell in all
the cells behind the chart. I have many applications that rely on
this to be true.

In Excel 2007, even doing the tricks above do not get the Chart to
update in real-time. I have to release the mouse button to get it to
update. This is terrible. Is there another trick I need to do to
regain prior functionality?

Thanks in advance.