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")

score 2 · Accepted Answer · edited May 23 '17 at 12:12

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 '17 at 12:12

Community

1
1

answered Apr 16 '13 at 11:37

Siddharth Rout

147,039
17
206
250

Thanks Siddharth. It Worked ! – user2242660 Apr 16 '13 at 12:04

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

1 Answers1