View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Color change for Column Chart

See attached Screen shot sample.
http://cjoint.com/?fev2shbXLa

"John" wrote in message
...
Hi Everyone
I'm using a column chart, always 4 columns.
Is it possible to have each column change color automatically based on
criteria Below 7 = Green
Between 7 and 9.9 = Orange
10 and above = Red

TIA
John