View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
Steve B Steve B is offline
external usenet poster
 
Posts: 21
Default Maximum number of data points for an xy scatter chart?

I just saw the post about this problem. However that did not help me much.
Sorry for the double post.

"Steve B" wrote:

I have a question that is related to this. I have a line graph that contains
8000 points per series, and I have 2 series set up. And I know that the max
number of points per series is 32000 but I keep getting an error message
telling me the maximum number of points per series. Why is that? Does it
take into account the x-category as well? And even if it did I would still
only have 16000 "points" per series?

"Jon Peltier" wrote:

32000 points per series, 256000 points per chart.

Think about it. I just created a default chart in Excel 2003. The size
depends on monitor resolution and usable size of the active window, but in
any case, the chart area measured 428 x 257 points, and the plot area 370 *
241 points. That means 493 x 321 pixels, so the pixels in the chart area is
something like 158000, which includes the axis lines and plot area border.
Excel allows more data points than it has pixels in a chart. How are you
going to display them all?

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


"WG" wrote in message
...


"Phil Preen" wrote:

Is there a max number of data points an XY chart can
use?

I think the maximum is 32000 points per series.