This should be a quick and easy one. I have 30 trends in which I would like to change the colour of trace/pen 2 to a different colour with VBA. The looping part is easy, but which method should I use do change the trace colours?
I have tried to use 'current_trend.LineColor' which only changes the colour of the markers.
GetFormat -> .item(1).color = ### -> SetFormat gives 'does not support method' error.