View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Warning message on "number of data points"

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"h" wrote in message
...
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" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chart blues" <Chart wrote in message
...
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!