Thread: Convert Chart Series Formula to Array Via VBA?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_7_] Jon Peltier[_7_] is offline
external usenet poster
  
Posts: 115
Default Convert Chart Series Formula to Array Via VBA?
Answered in the charting group.

- 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:R 100C10,FirstFeltData!R2C66
:R100C66,1)"



Reply With QuoteReply With Quote