I tried to emulate a sankey chart with a line chart in excel 2021. (for having direct access to the Charts events i use a chart as Chartsheet) I have 36 lines within this chart and i use the Series.format.line.weight property for changing the weight for each line. The line weight is taken by code from a range in a Worksheet. All my code works fine but if i change the values in the range for the line.weight by looping through, the changes don’t reliable take effect on the properties of the chart
part of my code: