Hello,

I have done this in the past by writing a macro...Excel assigns random
colors to charts, so sometimes by changing your data the color of
certain columns changes. i could not find the online reference i used
but try to find/write the macro to do that.
Hope this will help (i'll look for the code and i'll reply back if
found)


--
Richard Flame
------------------------------------------------------------------------
Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944
View this thread: http://www.excelforum.com/showthread...hreadid=557866