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

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

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

Sometimes it's easier to use a VBA procedu

http://peltiertech.com/WordPress/200...y-series-name/
http://peltiertech.com/WordPress/200...ategory-label/
http://peltiertech.com/WordPress/200...arts-by-value/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Blossom*" wrote in message
...
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

Thanks Jon,

Will have a try and let you know

Thank you
--
Blossom


"Jon Peltier" wrote:

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

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

Sometimes it's easier to use a VBA procedu

http://peltiertech.com/WordPress/200...y-series-name/
http://peltiertech.com/WordPress/200...ategory-label/
http://peltiertech.com/WordPress/200...arts-by-value/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Blossom*" wrote in message
...
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

Thanks a million :-)

Used - VBA Conditional Formatting of Charts by Category Label

Thanks again
--
Blossom


"Jon Peltier" wrote:

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

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

Sometimes it's easier to use a VBA procedu

http://peltiertech.com/WordPress/200...y-series-name/
http://peltiertech.com/WordPress/200...ategory-label/
http://peltiertech.com/WordPress/200...arts-by-value/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Blossom*" wrote in message
...
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