Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Supressing warning about too many data points in a chart series.

I have a line that I have converted from VBA to C# that looks like:

ws.Shapes.AddChart(Excel.XlChartType.xlLine, Type.Missing,
Type.Missing, Type.Missing, Type.Missing).Select(false);

The problem with this line is that I get a message box warning me that if
there are more than 32,000 data points in the series I will have to make more
than one series. At this point I am just trying to add a blank chart. The VBA
code looks like:

ActiveSheet.Shapes.AddChart.Select

but it doesn't give this warning. As I see it there is nothing in the
AddChart to indicate the number of points involved. That would be later in
SetSourceData. But the error/warning is happening here. Any way I can
suppress this warning. If I simply cliick OK the chart is created just fine.
I just want this warning message to go away.

Thank you.

Kevin


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Series and Creating data points within a series Cristal Excel Discussion (Misc queries) 2 November 30th 09 08:07 PM
Excel Chart - Too many data points in Series? Will H. Excel Discussion (Misc queries) 1 December 16th 08 07:35 AM
not able to link chart points from same series [email protected] Charts and Charting in Excel 1 September 19th 06 01:36 PM
Line chart with two series; how to add points to one and not the other? chowgirl Charts and Charting in Excel 0 February 8th 06 09:10 PM
supressing system warning messages ppete83606[_2_] Excel Programming 3 September 15th 05 05:21 AM


All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"