Is there a way to access the color of a new series line in a scatter chart that is created dynamically using VBA? I want to take the color of the line of the new series and put it as the background of a cell near where the data is for the new series.
I can't seem to find how to access the color of a series when it is created.