Error '1004' “Invalid Parameter” in Data Labels, Chart

Hello

I have this chart / graph from here : https://www.officetimeline.com/excel-timeline

It has to be a dynamic so i have to make a macro searching for the specific ranges.

The problems is at the "6.Add titles to your timeline's milestones" (Part B and C) category where when i try to update the Data Label Range From Cells it gives me "Error '1004' “Invalid Parameter” " even if i use record macro feature.

This is the problem :

    'ActiveChart.SeriesCollection(6).DataLabels.Format.TextFrame2.TextRange. _
        InsertChartField msoChartFieldRange, "='Daily'!$AB$8:$AB$18", 0

Note that if i do it manually, the Range is working perfectly. Why is that ?

Thank you.