Dynamically change column color in chart
 

It's been a while since I was in here...
I'm wondering if it's possible to create a column chart
where the color of each column changes according to data in
a separate source range. For example, graph the numbers in
column A, and determine their color using the values in
column B. There are only 2 or 3 different possible colors.
Perhaps a series for each? Thanks for any suggestions.

Out of practice,
Everett

Dynamically change column color in chart
 

Hi Everett -

In my simple conditional chart example, I use a series for each color:
http://www.geocities.com/jonpeltier/...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Everett wrote:
It's been a while since I was in here...
I'm wondering if it's possible to create a column chart
where the color of each column changes according to data in
a separate source range. For example, graph the numbers in
column A, and determine their color using the values in
column B. There are only 2 or 3 different possible colors.
Perhaps a series for each? Thanks for any suggestions.

Out of practice,
Everett