numberland10
New Member
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 lots of manual color adjustments.
Any suggestions???
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 lots of manual color adjustments.
Any suggestions???