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 : 
Please Login or Register  to view this content.
Note that if i do it manually, the Range is working perfectly. Why is that ?

Thank you.