View Single Post
  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

I don't know of anyway too suppress the message.

Any reason why you can not adjust your data series so it only uses the
maximum number of values or following the advice and use extra data series?

Cheers
Andy

Greg G wrote:
Hello,
I would like to know if there is a way to prevent excel from
displaying the alert that says "The maximum number of data points you can use
in a data series for a 2-D chart is 32,000. If you want to use more than
32,000 data points, you must create two or more series." every time that a
chart is opened. It also displays when the file is closed. I've tried
closing the file with a macro with display alerts set to false but it still
appears. You have to click ok before it will continue to close. I would
really appreciate any information about this. Thank you.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info