Maximum number of data points for an xy scatter chart?

Rich F · 10-12-2005, 06:05 AM

If I select a portion of the data I can draw an XY chart. When I select the
entire data range the chart automatically changes from an XY to a line chart,
even with XY specified. Is there a max number of data points an XY chart can
use? I am trying to compare the hourly average of 2 variables over a 1 year
period.

Phil Preen · 10-12-2005, 07:05 AM

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

I think the maximum is 32000 points per series.

Rich F · 10-12-2005, 08:05 AM

Thanks Phil, that will be useful for future reference. I actually did
discover, just now, what my problem was. I had downloaded the data from
another source, and there was a blank cell amongst the data. This caused the
chart to change from an XY to a line chart as there was no "x" for the "y" at
that point. Thought I'd post this as it may be useful to others.

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

Jon Peltier · 10-15-2005, 10:05 AM

And 256000 total points per chart. These values are enough to turn a
chart into an undifferentiated mass, but I have a client who wants 1M+
points per chart!

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

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.

**yn0mtan5t** · 03-11-2017, 04:03 PM

Please understand that closing questions is as important as asking them. 210-065 PDF Dumps If you are still here and still an active member, you must have received dozens of reminders from EE in the past to close this question. The EE site is trying to help you do the right thing. I can't understand how you managed NOT to sign it off sooner. What would have helped you do that?
210-060 Dumps