Is there a way to select the color of data points in a chart from the
values of cells? I want to generate a stacked chart in which the boxes
of one column should have colors that depend on the values of another
column. Doing it manually is not an option since the chart contains
some hundreds of series and should be updated on a monthly basis.:)
Thanks


--
kmav
------------------------------------------------------------------------
kmav's Profile: http://www.excelforum.com/member.php...o&userid=32665
View this thread: http://www.excelforum.com/showthread...hreadid=524706