My Code below:
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")

Thanks in advance.