Runtime error 9 when trying to create a chart from a different Workbooks' data

So, The main reason I was running in to this issue was that Excel needs the other workbook(s) to be open while plotting graphs AND the workbook in which the graph to be plotted as active. So I've modified the code to open the other workbooks, make the one in which I'm plotting the graph active, plot the graph and then close.

target_workbook.xlsm is the workbook in which the graph has to be drawn, and asd.xlsx is workbook which contains the data.

Private Sub CommandButton1_Click()
Dim wb As Workbook
Dim ws As Worksheet
Dim rng As Range

Workbooks.Open "C:\full_path_to_file\asd.xlsx"
Workbooks("target_workbook.xlsm").Activate

Set wb = Workbooks("asd.xlsx")
Set ws = wb.Worksheets("Sheet ABC")
Set rng = ws.Range("F3:F98,H3:H98")

MsgBox ("Test-1!")
Set chrt = Sheets("Sheet1").ChartObjects.Add(Left:=5, Width:=600, Top:=7, Height:=350)
chrt.Chart.SetSourceData Source:=rng
chrt.Chart.ChartType = xlLine
MsgBox ("test-2")

Workbooks("asd").Close SaveChanges:=False
End Sub