color coding in the pie chart

[aaronnayan]

Hi Guys i am in need of you help

So guys i need to color code the font in my chart so when the number is a certain value it would change color for example

0-50 red

51-70 yellow

71+ green

I have made the font for the chart in "text in chart" which is in the presentation tab.

I have also created 3 variables that have the certain values set

vmin

vmid

vhigh

i appreciate anyone's help as this is a tough one to crack

many thanks guys

[ahaahaaha]

Hi Aaron,

Can there be a formula for the color you entered not on the desired tab? Look at the attached file, please.

Regards,

Andrey

[MK_QSL · Accepted solution]

Do you want to change color of Font in TEXT IN CHART ?

Use something as below for Calculated Color expression

=IF(SUM(Value)>=0 and SUM(Value) <= 50, RED(),

IF(SUM(Value)>=51 and SUM(Value) <= 70, YELLOW(),

Green())))

[aaronnayan]

Hi Andrey,

no not there it is in the presentation tab.

It is in the text in the chart area

[aaronnayan]

Hi Manisha that was spot on thankyou

[MK_QSL]

Glad that it worked for you.. Would be more happy if you write my name correctly ... !!