A bar can only be 1 color. You can possibly rearrange your data and use a
stacked bar chart.

--
Regards,
Tom Ogilvy


"tweety127" wrote:


hi, is it possible to automatically change the color of the bar chart as
soon as it reached the maximum point?...


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=549967