BB -

You might be able to make a conditional chart with your data:

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

It will cost you a few extra columns and some formulas, but it is dynamic as the
data changes, whereas the VBA procedure would have to be rerun.

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

Booger_Boy wrote:

When creating a chart off of a table, the colors of each column appear to be
in the order of their display in the chart. For example, let's say I have
January data as red, February data as white and March data as blue. Then I
sort the table in the Excel sheet by value. Now the labels are ordered
February, March, January. Well, now the first column (February) is red, the
second (March) white and the third (January)blue.

Is there a method to hard-code the column color to the data label in the
charts rather than simply the order that the data appears?