Charting Options Other Than Excel?

[MDW]

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.

 

[Tushar Mehta]

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

 

[MDW]

I'll check that, thx.

 

[Jon Peltier]

Also check the Vary Colors By Point option.

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