Warning message on "number of data points"

[Chart blues]

I am plotting 24 hour rolling data that gets updated every minute. Data
comes from an Excel Query data base and is graphed in four different charts
(separate worksheets). Refresh is enabled when opening file but before the
actual charts update a warning message comes on several times, which 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" I don't really know what all this exactly means
and what "two or more series" it is talking about. Can someone please help?
Thanks!

 

[Jon Peltier]

A series is a single set of data defined by a set of formatting options. If
you have over 32k points, you can make a series with the first 32k points,
then add as many as necessary blocks of 32k more points as new series, and
format them all to look like the first.

Of course, if you have over 32k points, nobody can probably read the chart.

- Jon

 

[Chart blues]

Jon: Thanks for your help... it worked beautifully!

 

[h]

I have around 120k data points.I made multiple series of each 30k points.But
i want them to look like a continutaion. they appear as 4 different charts

 

[Jon Peltier]

You mean as four different series. Format them the same way (same color
line, same style marker).

- Jon

 

[CR]

Hi..
I have less than 32 000 data points and I keep having this warning on my
chart !! It is really boring !!!

Many thanks for your help,

Camille

 

[Jon Peltier]

What kind of chart? 2D or 3D? What version of Excel?

- Jon

 

[pm0203]

I had the same problem.

Solution:

1. Fix any compile errors in VBA macros
2. Change the source data for all series. Add a row and lengthen the
series.

Should be fixed now.

Appears to be a slight corruption in the excel workbook for the graph.

The error message box would appear without fail if an extra row was
added to the source data which was on a separate sheet.
Once the source data series was changed the problem went away.