Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems changing x-axis with large data sets Helena Charts and Charting in Excel 2 June 9th 08 09:05 AM
manipulating large data sets for graphing steveb[_2_] Excel Discussion (Misc queries) 2 October 30th 07 03:03 PM
Comparing Large Data Sets in Excel JohnnyCJohnny Excel Programming 1 February 23rd 07 12:11 AM
VLOOKUP in large Data sets of more than 16384 rows Bluewolf Excel Worksheet Functions 11 April 3rd 06 09:39 PM
how to save large data sets in excel sheck Excel Discussion (Misc queries) 1 August 2nd 05 07:02 AM


All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"