Excel 2013 VBA change a chart object source using dynamic range

Question

I am trying to dynamically set a chart object source. The fdc and ldc variables will change over time. I've tried several variations of code; my latest attempt being:

fdc = 26
ldc = 90
ws.ChartObjects("Chart 2").SetSourceData Source:=ws.Range("S" & fdc & ":V" & ldc)

but they all give:

Run-time error '438': Object doesn't support this property or method.

Rik Sportel · Accepted Answer · 2018-05-23 11:29:08Z

2

You're referring to the ChartObject. SetSourceData is a method of the Chart inside the ChartObject.

Try

fdc = 26
ldc = 90
ws.ChartObjects("Chart 2").Chart.SetSourceData Source:=ws.Range("S" & fdc & ":V" & ldc)

edited May 23, 2018 at 11:29

answered May 23, 2018 at 11:04

Rik Sportel

2,6781 gold badge17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jason Stallard Over a year ago

Excellent. I had read this several times when searching for a solution but I didn't see how to apply it to my situation.

Jason Stallard Over a year ago

It did but I had to wait two minutes before I could mark it as an answer.

Collectives™ on Stack Overflow

Excel 2013 VBA change a chart object source using dynamic range

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related