Unable to set the formula property of the series class

M

Malhar

Hi Guys,


I am struggling with one problem. I am trying to change formulae o
series in a chart using VBA code given below. But I am getting

'Runtime Error 1004, Unable to set the formula property of the serie
class'


Code
-------------------


ActiveChart.SeriesCollection(1).Formula = _
Replace(ActiveChart.SeriesCollection(1).Formula, "Sheet1", "test")


-------------------



Can anybody Please suggest some solution?

Thanks,

MH
 

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

unable to set the values property of the series class 3
Changing ChartTypes will not change the color of the Series 2
Unable to set the XValues property of the Series class 5
Unable to set the Values property of the Series class 1
How can I extract the XValues Formual String 1
Cannot change Series references 4
Unable to set the XValues property of the Series class 4
Cannot assign a range to seriecollection values 3

Top