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

--
kma
-----------------------------------------------------------------------
kmav's Profile: http://www.excelforum.com/member.php...fo&userid=3266
View this thread: http://www.excelforum.com/showthread.php?threadid=52470

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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