View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Everett[_2_] Everett[_2_] is offline
external usenet poster
 
Posts: 1
Default 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