Thread: Color data points

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

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" <kmav.250hla_1142931001.2281@excelforum-nospam.com> wrote in message
news:kmav.250hla_1142931001.2281@excelforum-nospam.com...
>
> 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