Thanks for reading this, I'm still kinda of new to VBA. I'm trying to figure out how I should define ActiveChart in way similar to how I defined wk6.

I tried
Dim cht As Object
Set cht = ThisWorkbook.Worksheets("ITF_Chart").ActiveChart
Below is the code as of now with active chart highlighted in bold.


 Dim wk6 As Worksheet
    Set wk6 = ThisWorkbook.Worksheets("ITF_Chart")
       

 wk6.Columns("Q:Q").NumberFormat = "$#,##0"
    wk6.Columns("R:R").NumberFormat = "$#,##0"
    Selection.CurrentRegion.Select
    wk6.Shapes.AddChart2(201, xlColumnClustered).Select
    ActiveChart.SetSourceData Source:=Range("ITF_Chart!$N$7:$R$19")
    ActiveChart.ChartTitle.Text = "Q1 ITF"