Kind of odd to be posting this in an Excel NG, I know, but

I'm using Excel 2000, trying to create an X-Y chart. I've got 2 columns of info and I'm looking to trand-spot any relationships between the two. However, I've got near to 600 data points to map, but according to what Excel tells me, I'm only allowed to use 255??

True? False? What are my other options, if any

This is the first time I've had so many data points, so I've never bumped up against this ceiling before.

I believe XL's limit is 32,000 data points in a series. Maybe -- and I
don't know for sure -- the 255 refers to the number of series.

When creating the chart, in step 2 of the wizard, ensure you select the
'Series in column' option.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <CEA94738-2AB8-4573-ABC2-(E-Mail Removed)>,
(E-Mail Removed) says...
> Kind of odd to be posting this in an Excel NG, I know, but -
>
> I'm using Excel 2000, trying to create an X-Y chart. I've got 2 columns of info and I'm looking to trand-spot any relationships between the two. However, I've got near to 600 data points to map, but according to what Excel tells me, I'm only allowed to use 255???
>
> True? False? What are my other options, if any?
>
> This is the first time I've had so many data points, so I've never bumped up against this ceiling before.
>

I'll check that, thx.

Also check the Vary Colors By Point option.

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

Tushar Mehta wrote:

> I believe XL's limit is 32,000 data points in a series. Maybe -- and I
> don't know for sure -- the 255 refers to the number of series.
>
> When creating the chart, in step 2 of the wizard, ensure you select the
> 'Series in column' option.
>