32000 chart limit warning

's Computer Specifications

I have a worksheet with more than 32000 data rows. I'm trying to chart it
using multiple series. When I call Charts.Add or Shapes.ChartAdd methods, I
get a warning about trying to chart more than 32000 points. However, my code
is doing the right thing as the chart is generated properly. Is there any way
to turn off this warning?

's Computer Specifications

Hi

Have you tried Application.DisplayAlerts = False before Charts.Add method

Cheers
Shasur
--
http://vbadud.blogspot.com

"bucweat" wrote:

> I have a worksheet with more than 32000 data rows. I'm trying to chart it
> using multiple series. When I call Charts.Add or Shapes.ChartAdd methods, I
> get a warning about trying to chart more than 32000 points. However, my code
> is doing the right thing as the chart is generated properly. Is there any way
> to turn off this warning?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Plotting more than 32000 points on a chart	inquirer	Microsoft Excel Programming	10	17th Aug 2006 09:41 PM
I have 32000+ duplicate emails!	=?Utf-8?B?YmRsb3d0ZWs=?=	Microsoft Outlook Discussion	1	2nd Feb 2005 04:50 PM
Re: warning C4049: compiler limit	Carl Daniel [VC++ MVP]	Microsoft VC .NET	1	4th Sep 2003 04:35 PM
Re: warning C4049: compiler limit	William DePalo [MVP VC++ ]	Microsoft VC .NET	0	4th Sep 2003 04:23 PM
Re: 32000 data point limit	Bernard V Liengme	Microsoft Excel Charting	2	21st Aug 2003 11:17 PM