I have some VBA code in Excel 2007 that creates plots, this process is fairly fast.
However I then reformat the scatter plot data points. This is slow.
I have turned off screen updating, but it still takes >10s (on a fast i7 machine).
Are there any other ways to speed up plotting and updating of existing plots? I cannot find anything other than screen updating.