Not only is the formula length limited to 1024, but each piece of the
formula (Values, XValues) is limited to 256. So you'll never even
approach 1024.

On this web page I discuss some strategies to increase the number of
values you can squeeze into 256 characters:

http://peltiertech.com/Excel/ChartsH...ChartData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tom Ogilvy wrote:

after you successfully assign the array, look at the chart and select that
series. Look in the formula bar to see how your data is stored. The
maximum length of a formula is 1024 characters. I suspect you are bumping
up against this limitation.