Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default is there a limt to the number of points ?

I have a program which plots data on a chart and it has been working
fine until today when I tried to plot a large data set.
There are about 59000 points to plot and the program seems to call a
halt at about 32000 or so (I haven't yet found out exactly where it stops).

I thought it may be because I had a counter declared as an integer but I
changed all integer declarations to long but it still stops at the same
place.

Does anyone know if there is a limit on the number of points that can be
plotted on one chart?
Thanks
Chris
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default is there a limt to the number of points ?

Chris,
Creating a chart with 51K points, I get an error of "The maximum number of
data points you can use is for a 2-D chart 32000.....to use 32000 data
points, you must create 2 or more series."
So seems built in limit.

NickHK

"inquirer" wrote in message
...
I have a program which plots data on a chart and it has been working
fine until today when I tried to plot a large data set.
There are about 59000 points to plot and the program seems to call a
halt at about 32000 or so (I haven't yet found out exactly where it

stops).

I thought it may be because I had a counter declared as an integer but I
changed all integer declarations to long but it still stops at the same
place.

Does anyone know if there is a limit on the number of points that can be
plotted on one chart?
Thanks
Chris



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default is there a limt to the number of points ?

NickHK wrote:
Chris,
Creating a chart with 51K points, I get an error of "The maximum number of
data points you can use is for a 2-D chart 32000.....to use 32000 data
points, you must create 2 or more series."
So seems built in limit.

NickHK

"inquirer" wrote in message
...
I have a program which plots data on a chart and it has been working
fine until today when I tried to plot a large data set.
There are about 59000 points to plot and the program seems to call a
halt at about 32000 or so (I haven't yet found out exactly where it

stops).
I thought it may be because I had a counter declared as an integer but I
changed all integer declarations to long but it still stops at the same
place.

Does anyone know if there is a limit on the number of points that can be
plotted on one chart?
Thanks
Chris



Thanks Nick - I wasnt getting any error message so I was in the dark.
I'll have to see how I can program in a second series.
Chris
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
Custom number format for basis points [email protected] Excel Discussion (Misc queries) 0 November 22nd 06 07:06 PM
is there a limt to the amount of if statements you use in just 1 c unouwanme Excel Discussion (Misc queries) 8 August 24th 06 11:59 AM
number has bogus decimal points Librarian New Users to Excel 3 December 2nd 05 12:51 AM
How do I reduce the number of data points I have?? ssanjan Charts and Charting in Excel 1 July 31st 05 05:32 AM
Data Validation Drop-down List Limt? Jim D. Excel Programming 2 June 23rd 05 12:07 AM


All times are GMT +1. The time now is 01:50 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"