View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Maximum number of data points for an xy scatter chart?

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.