Prev: limit range to unique values
Next: Can this be done?
From: John on 4 May 2010 15:47
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
From: John on 4 May 2010 15:57
See attached Screen shot sample.
http://cjoint.com/?fev2shbXLa

"John" <johnd(a)newlook.com> wrote in message
news:%23US6gK86KHA.6052(a)TK2MSFTNGP02.phx.gbl...
> 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

From: Peter T on 4 May 2010 17:40
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" <johnd(a)newlook.com> wrote in message
news:%23US6gK86KHA.6052(a)TK2MSFTNGP02.phx.gbl...
> 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


From: John on 4 May 2010 18:06
Hi Peter
I will have a look at it, thank you.
Regards
John
"Peter T" <peter_t(a)discussions> wrote in message
news:%23myAhJ96KHA.4508(a)TK2MSFTNGP06.phx.gbl...
> 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" <johnd(a)newlook.com> wrote in message
> news:%23US6gK86KHA.6052(a)TK2MSFTNGP02.phx.gbl...
>> 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
>
>

From: John on 4 May 2010 22:11
Hi Peter
I got it working, Thanks again
John
"Peter T" <peter_t(a)discussions> wrote in message
news:%23myAhJ96KHA.4508(a)TK2MSFTNGP06.phx.gbl...
> 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" <johnd(a)newlook.com> wrote in message
> news:%23US6gK86KHA.6052(a)TK2MSFTNGP02.phx.gbl...
>> 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
>
>

 | 
Pages: 1
Prev: limit range to unique values
Next: Can this be done?