Color change for Column Chart
 

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

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

Color change for Column Chart
 

From Jon Peltier's main page

http://peltiertech.com/

search "conditional" without the quotes. The Simple conditional column chart
looks like what you're after.

Regards,
Peter T


"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

Color change for Column Chart
 

Hi Peter
I will have a look at it, thank you.
Regards
John
"Peter T" <peter_t@discussions wrote in message
...
From Jon Peltier's main page

http://peltiertech.com/

search "conditional" without the quotes. The Simple conditional column chart
looks like what you're after.

Regards,
Peter T


"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

Color change for Column Chart
 

Hi Peter
I got it working, Thanks again
John
"Peter T" <peter_t@discussions wrote in message
...
From Jon Peltier's main page

http://peltiertech.com/

search "conditional" without the quotes. The Simple conditional column chart
looks like what you're after.

Regards,
Peter T


"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