Warning message on "number of data points"
 

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!

Warning message on "number of data points"
 

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!

Warning message on "number of data points"
 

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

"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!

Warning message on "number of data points"
 

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!

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!

Warning message on "number of data points"
 

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" wrote:

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!

Warning message on "number of data points"
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


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

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!