When I reread your post, I realize there are still issues with charts and
VBA. It is hard to reliably position the plot area of a chart within the
chart area. Usually it works fine, but sometimes there is a magic number of
points that the .top or .left of the plotarea cannot attain, and you need to
use a bunch of iteration to get as close as you can. Positioning the inner
plot area can only be done indirectly by positioning the (outer) plot area
while taking into account the margins required for labels and such.
Supposedly using the old XLM macro commands are more reliable, but I never
really learned these.

Apparently the Excel designers turn off not just the screen display but
calculations of where screen elements should display, when screen updating
is False; especially on older computers, complicated charts can be very slow
to redraw. You might avoid the need for screen updating if you sprinkle
DoEvents statements within the offending code. It makes Excel go through the
screen calculations without actually updating the screen. DoEvents doesn't
help with the precision problem I mentioned above, but it helps with getting
a freshly redrawn chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Tim" wrote in message
oups.com...
Thanks Jon

I am using Excel 2003 which I thought would have got rid of bugs from
the 97 version, strange