Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow chart problems with very large data sets
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems changing x-axis with large data sets | Charts and Charting in Excel | |||
manipulating large data sets for graphing | Excel Discussion (Misc queries) | |||
Comparing Large Data Sets in Excel | Excel Programming | |||
VLOOKUP in large Data sets of more than 16384 rows | Excel Worksheet Functions | |||
how to save large data sets in excel | Excel Discussion (Misc queries) |