View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_7_] Jon Peltier[_7_] is offline
external usenet poster
 
Posts: 115
Default Exceeding Max. (32,000) Data Points in a Series

If you have multiple series in your chart, this will happen. You can
hide the redrawing if you put your code between these two lines:

Application.ScreenUpdating = False

Application.ScreenUpdating = True

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Jonnyboy117 < wrote:

Thanks very much! This code seems to make it run more cleanly, although
I can still see the plot being redrawn several times. I guess I don't
understand the plotting functions at all.


---
Message posted from http://www.ExcelForum.com/