Run Time Error 91 - Object variable or With block variable not set when using Pie Chart in Excel

Question

My Code:

Sub PieSourceData()
    Sheets("ReportSummary").ChartObjects("Chart 5").Activate
    Sheets("DataSheet").Select
    ActiveChart.SetSourceData Source:=Range("A245:B249")
End Sub

It is failing at the line :

ActiveChart.SetSourceData Source:=Range("A245:B249")

Community · Accepted Answer · 2017-05-23 12:12:35Z

2

The culprit is this line

 Sheets("DataSheet").Select

If you select that sheet then how is the chart active then ;)

And hence I always suggest to avoid the use of .Select. See this link.

Try this

Sub PieSourceData()
    Sheets("ReportSummary").ChartObjects("Chart 1").Activate
    ActiveChart.SetSourceData Source:=Sheets("DataSheet").Range("A245:B249")
End Sub

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Apr 16, 2013 at 11:37

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

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

1 Comment

user2242660 Over a year ago

Thanks Siddharth. It Worked !

Collectives™ on Stack Overflow

Run Time Error 91 - Object variable or With block variable not set when using Pie Chart in Excel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related