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 :
Note that if i do it manually, the Range is working perfectly. Why is that ?
Thank you.
P.S this question was posted also on :
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 :
Code:
'ActiveChart.SeriesCollection(6).DataLabels.Format.TextFrame2.TextRange. _
InsertChartField msoChartFieldRange, "='Daily'!$AB$8:$AB$18", 0Note that if i do it manually, the Range is working perfectly. Why is that ?
Thank you.
P.S this question was posted also on :
Code:
https://www.excelforum.com/excel-programming-vba-macros/1191697-error-1004-invalid-parameter-in-data-labels-chart.html, but still not answered
