If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! |
#6
|
|||
|
|||
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! |
#7
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|