I am trying to convert the Chart series formula below to an array via VBA. I
have tried recording a macro and have had no success. I used the select
series, click in the formula bar and hit F9 and this does not work.
Can anyone help?

Formula =
"=SERIES(FirstFeltData!R1C65,FirstFeltData!R2C10:R100C10,FirstFeltData!R2C66
:R100C66,1)"

Kevin -

It works only for a limited number of points, not because of the number
of points, but because of the characters required to describe them. You
can read more about the problem and possible workarounds here:

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

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

Kevin G wrote:

> I am trying to convert the Chart series formula below to an array via VBA. I
> have tried recording a macro and have had no success. I used the select
> series, click in the formula bar and hit F9 and this does not work.
> Can anyone help?
>
> Formula =
> "=SERIES(FirstFeltData!R1C65,FirstFeltData!R2C10:R100C10,FirstFeltData!R2C66
> :R100C66,1)"
>
>
>