Active chart refreshes slower in 2007

[hmm]

I create active charts with a spin button (Form control) to flip through many
sets of y data (by incrementing the y-series row-references using an index
controlled by the button).

When I used Excel 2000, I used to place the button inside of the chart.
(That is where you can only drag it as far as the edge of the chart area,
much like placing a text box inside of a chart). By placing it inside, data
series refreshed much faster than if it were outside (in the worksheet area
itself). In the former case, I was able to flip through all series by
holding down the mouse the spin button arrow; every single series would
appear and the chart would update very quickly.

In Excel 2007, as far as I can see, Form controls are not placed inside the
chart (they can be dragged out). Updating of charts is slower (a discernible
fraction of a second compared with pratically instantaneous, for a 2000-point
series). Worse, if I hold down over the spin button, the series does not
update until I release the mouse button. As such, there is no fast-action
flipping through data; I have to hold, release and wait for viewing each new
series.

If anyone has a fix around this problem, please let me know. I would
appreciate any insights about the nature of this problem and how to solve it.

Thanks.

 

[Jon Peltier]

1. Controls not allowed "in" an embedded chart: new "feature" in 2007.
2. Slower chart update: new "feature" in 2007.
3. It may be possible to get better continuity if you use a Controls Toolbox
spin button instead of the Forms toolbar spinner.

- Jon

 

[hmm]

Thanks for your help, Jon.

I tried using the ActiveX Control version of the spin box in 2007. Sorry to
say, it did not offer any improvement in speed over its Forms counterpart.
Is there another way of solving the problem, e.g., by a macro that bypasses
the slower process and substitutes a faster one?

I hope that you or anyone else who has clout with Microsoft will tell them
it was a mistake to remove such a valuable feature, and that they should
reinstate it with their next update.

 

[Jon Peltier]

I suspect any macro that tried accomplishing this would be even worse
performing than the built-in approaches.

- Jon