P
professorplum101
I need some advice on how to speed up excel when plotting multiple
extremely large data sets (up to the 32,000 point limit). Right now,
the code that I am working with uses a user input form to control
various aspects of the chart, like which series will be plotted, which
axis to plot them on, etc. The problem is that the redraw time is
incredibly slow when the data set size gets very large.
I have turned off screen update in the appropriate places. However,
when I have data sets up near the 32,000 point limit, excel like to
get stuck (or nearly stuck) at the point in the code where screen
update is turned back on. Any advice on this would be very helpful.
extremely large data sets (up to the 32,000 point limit). Right now,
the code that I am working with uses a user input form to control
various aspects of the chart, like which series will be plotted, which
axis to plot them on, etc. The problem is that the redraw time is
incredibly slow when the data set size gets very large.
I have turned off screen update in the appropriate places. However,
when I have data sets up near the 32,000 point limit, excel like to
get stuck (or nearly stuck) at the point in the code where screen
update is turned back on. Any advice on this would be very helpful.