Changing series formula

G

Guest

Hello,

Im using the WorksheetFunction.Substitute code to change a series formula. But when a series sources data which is #NA, the code wont work, as the data is not visible on the chart. Anyway around this to change those series also?

many thanks ahead.
 
J

Jon Peltier

Ali -

Convert the series type to xlArea first, then you'll be able to access
the series.

- Jon
 

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

Change Series Formulas for all charts on worksheet 4
User Selectable Series and Number of Series for Line Chart 2
Not plot a data series in a chart but still display in data table 1
Odd Chart Format Results 1
Change Chart Series Formula 13
Convert Error Bars to Series and Colour 1
Paste new SERIES() in formula bar 2
Changing font style/size/color/etc for multiple series in a chart? 3

Top