Convert Chart Series Formula to Array Via VBA?

  • Thread starter Thread starter Kevin G
  • Start date Start date
K

Kevin G

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)"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: Chart & data 1
SeriesCollection(2).Formula returns formula for series 1 1
Referencing Chart Data? 1
Is it possible to multiply a chart series formula? 4
Why do charts disappear? 2
Delete chart series 2
Bubble Chart 1
programming 33 tabs with 1 chart on each, 9 series lines per chart 1

Back
Top