Like a series name, I'd like a data series color to be linked to a data element in the worksheet. How do I do this? Is there a special coding?
I ask b/c I resort my data often as it changes, and the series colour, if manually done, is linked to the row number, not the data series, which means...