Hi there,

Is it possible to have a particular colour for each series that will stay
the same regardless of where the series is moved to.

My problem is that as data series are updated with new data we overwrite the
existing data and save workbook with a different name so that we don't have
to re-do charts.

A is the organisation
B is the % of targets achieved

We then sort the data to rank the organisations which means that the
position of the bar on the bar chart changes and so does the colour.

How can I get the colour to stay the same for the series?

Thank you

--
Blossom