Slow chart problems with very large data sets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

.

Relevant Pages

  • Re: Slow chart problems with very large data sets
    ... A lot of recent upgraders to Excel 2007 have expressed this complaint, ... have yet to read about any remedy. ... I have turned off screen update in the appropriate places. ... get stuck (or nearly stuck) at the point in the code where screen ...
    (microsoft.public.excel.programming)
  • Re: Any good excel websites?
    ... I follow my own advice and currently have a stash that's up to 138 generic ... This is excellent advice. ... I do the exact same thing. ... Microsoft Excel MVP ...
    (microsoft.public.excel.worksheet.functions)
  • Read-Only wont go away.
    ... I've been working at this issue for some time now and all the advice I ... Familiar problem: ... So I checked the file properties and the "read-only" box is unchecked. ... Cleaned win temp and anything to do with excel. ...
    (microsoft.public.excel.newusers)
  • Re: Advice - Excel 2003 Compatibility
    ... Thanks so much for your quick and much needed advice. ... Microsoft MVP - Excel ... but all of the stores using the spreadsheet have 2003 and that's ... the rewrite needs to be done in. ...
    (microsoft.public.excel.misc)
  • Re: Listing data based on a referneced criteria
    ... I have followed the excellent advice below but it doesn't appear to work, ... I using the correct formula for the result I want? ... Excel 95 - Excel 2007 ... listed in column B if column E, I & S meets my criteria. ...
    (microsoft.public.excel.worksheet.functions)