32000 chart limit warning

B

bucweat

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

Shasur

Hi

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

Cheers
Shasur
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plotting more than 32000 points on a chart 10
How I can set dynamic pivot table ONLY when I have enough data point 1
Supressing warning about too many data points in a chart series. 0
is there a limt to the number of points ? 2
Line chart with dotted lines rendered poorly in presentation mode 0
stacked bar chart - problem adjusting bar width - Excel 2007 0
Data exceeds chart limits 2
Using =Offset in Charts 1

Top