Thanks. Great website with some other useful tips. But not exactly what I was looking for. I really wanted a way to reference a part of a data series (i.e. row in a set of data) that had a particular indicator in a cell (e.g., after the series name) that would tell excel the color for that...
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...