Chart bar colours

[Blossom*]

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

 

[Jon Peltier]

Sometimes you can make this work with formulas and extra series:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

Sometimes it's easier to use a VBA procedure:

http://peltiertech.com/WordPress/2008/03/03/vba-conditional-formatting-of-charts-by-series-name/
http://peltiertech.com/WordPress/2008/03/03/vba-conditional-formatting-of-charts-by-category-label/
http://peltiertech.com/WordPress/2008/03/03/vba-conditional-formatting-of-charts-by-value/

- Jon

 

[Blossom*]

Thanks Jon,

Will have a try and let you know

Thank you

 

[Blossom*]

Thanks a million

Used - VBA Conditional Formatting of Charts by Category Label

Thanks again