# Re: What does Excel do when you go over the limit for total data point

Usually I ask what's the use of showing more points in a chart than there
are pixels. But his time I thought I'd check it out.

I filled A1:L32001 (12 columns) with data. I tried to make a series with
A1:A32001, and Excel warned me that the limit was 32000 points per series.

I made a chart using A1:H32000 (8*32000=256000), which supposedly reaches
the maximum number of points in the chart. Fine, glad I'm using Excel 2003
and not 2007, because in the latter it would take a long time to redraw.
Then I extended the data range to I32000. No warning, and the new series was
added as if there was nothing wrong. I extended the range to column L, so I
have 12 series in the chart, each with 32000 points, which exceeds the limit
by 50%.

In VBA I ran command this from the Immediate window, with the following
results:

For Each s in ActiveChart.SeriesCollection : p = p + s.Points.Count : ?
s.Name, s.Points.Count, p : Next
Series1 32000 32000
Series2 32000 64000
Series3 32000 96000
Series4 32000 128000
Series5 32000 160000
Series6 32000 192000
Series7 32000 224000
Series8 32000 256000
Series9 32000 288000
Series10 32000 320000
Series11 32000 352000
Series12 32000 384000

So Excel thinks there are 384k points and is continuing happily along. I
don't know of any feasible way to tell which points are showing and which
(if any) have been filtered out.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
_______

"Carl" <Carl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B3AF515-913F-43F4-82F2-E21E2C560A04@xxxxxxxxxxxxxxxx
The maximum number of total data points in a plot is 256,000. However, I
have setup plots with > 1.5 million data points. Excel does not complain
thing is, I can't figure out which 256,000 it is showing. I don't think
it's
just the first 256,000 because the data is sorted and it would look
abruptly
cutoff after the 256,000th point.

I'm using a scatterplot if that helps. The plot looks correct, with
gradually decreasing density towards the outer edges of the plot. But if
it's only showing 17% of the data points, is Excel intelligently filtering
the data evenly?

.

• Follow-Ups:
• References:

## Relevant Pages

• Re: x-y plots
... I already have Excel set up to plot my data. ... I mean, I can tell you how to do it in Excel, but MS ... > Graph via Access doesn't seem to allow that option directly; ... Create form, insert chart object ...
(microsoft.public.access.gettingstarted)
• Re: Excel 2007: Lines not displaying on Scatter Plots
... Right click on the chart, choose Select Data, and click the ... Hidden and Empty Cells button on the bottom left corner of the dialog. ... Jon Peltier, Microsoft Excel MVP ... per data series and typically no more than 6 data series per plot). ...
(microsoft.public.excel.charting)
• Re: Excel 2007 Surface Plot with Logarithmic vertical axis crash
... Also if the chart is plotted in XL2003 and imported to 2007 ... Should i call Microsoft support to get a fix for this? ... I am attempting to plot a surface plot with a series of data in Excel ...
(microsoft.public.excel.charting)
• Re: What does Excel do when you go over the limit for total data p
... Thanks for the help, Jon. ... it would be much easier to let Excel figure out how to plot it all ... rather than writing my own code to filter the data before giving it to Excel. ... about this, but I'm guessing it is still only showing 256,000 points. ...
(microsoft.public.excel.charting)
• Re: Excel 2003 xy chart - problem plotting more than 330 points
... converts the XY chart to a line chart. ... To fix it, make sure the cell ... Jon Peltier, Microsoft Excel MVP ... > I'm trying to use the xy plot to plot around 12,000 points in one ...
(microsoft.public.excel.charting)