My KPI chart expression and setting not display correctly

[paulyeo11]

Hi All

My KPI chart have 2 issue :-

1. The color bar green is not display. now it display as white color.

2. My LY 2014 CCC is not display as 139. now display as blank.

How some one can help me ?

Paul

[mphekin12]

Hope this helps.

[paulyeo11]

Hi Sir

Thank you very much .

I make some mistake on my question . and the KPI chart color go wrong.

Actual i wanted :-

How to make 0 to 95 all green color ?

How to make 0 to -95 all red color ? ( now white color )

May i know how to achieve the above ?

Paul

[mphekin12 · Accepted solution]

Something like this?

[#5]

Hi,

For 1st Question: We need to change the setting. Go to Chart Properties->Presentation ,select Lower bound as 0 for Segment2 and Lower bound as -95 for Segment1.

For 2nd Question:  We need add text in Gauge chart.  Go to Chart Properties->Presentation- Click on add button from Text in Chart and  Inside Text write your above expression.

Now Press CTRL + SHIFT you will get Red Rectangles and drag and Drop to move the text box.

Please find attachment for you referance.

Thanks,

Uday

[paulyeo11]

Hi Sir

Thank you it work fine now.

My KPI is cash conversion cycle.

If the value -55 meaning is better. so i just change the color to green.

If the value +55 meaning is bad . so i just change the color to Red.

After i change green to red and red to green , Now it work.

Paul

[mphekin12]

Great!  Glad I was able to help.

[paulyeo11]

Hi Sir

Thank you.for.your detail expaination. 

Sent from Samsung Mobile

[#9]

You are welcome Paul