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

Read this page explaining how to achieve conditional formats in a chart:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"kmav" wrote in message
...

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