ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   is there a limt to the number of points ? (https://www.excelbanter.com/excel-programming/370506-there-limt-number-points.html)

inquirer

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

NickHK

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




inquirer

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


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com