Thanks John,
Your comments are appreciated.
btw thanks for the wealth of Excel Charting resources you provide on the web
I have found them to be a great benefit
Dave

"Jon Peltier" wrote:

Easier than trying to manipulate Names is to dump the data into a
worksheet, and plotting from the range. This is how Excel charts were
designed, and while they are flexible, this flexibility comes at the
expense of reliability.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/13/2010 4:58 AM, Peter T wrote:
The Series formula is limited to an absolute maximum of the 256 (or a tad
less) characters in each of the four (or five if Bubble) sections of the
formula.

Take this array -
{123.456789,123.456789,123.456789}
That's 34 characters, including the commas and curly brackets, from the
maximum 256.

There is a different way to accommodate virtually unlimited data in a Series
without use of cells, it involves defining the values as Named "vertical"
arrays. It's not straightforward.

Regards,
Peter T


wrote in message
...
Thought I might use arrays to collect chart series X and Y values from a
mass
of data (simplified example code below)
I found that with simple integers I can load a maximum of about 140
values.
With DateTime numbers this comes down to about 16 maximum.
Is this to be expected? (Excel 2003)

Dim myChtObj As ChartObject
Set myChtObj = Sheets("chart").ChartObjects("Chart 1")
With myChtObj.Chart
.SeriesCollection(1).Values = Array(4,5,6,...,n)
.SeriesCollection(1).XValues = Array(1,2,3,...,n)
End With


.