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

Why does Excel line chart cut off my data series? 4
Automatically selecting active chart 4
dynamic radar chart 1
create chart with column axis 10
Using =Offset in Charts 1
Using Variable array in Excel VBA charting 7
Chart Error when using Chart Line - Column on 2 Axes in vba code 2
Chart Property (e.g.: .HasTitle) reset fails with run-time error 1 4

Top