8020 bar chart with 3 color

[#1]

Hi All, 

I have a 8020 chart , which is working fine. Now the issue is i am not able to make the Bar into 3 color.

when inclusive % < 80% i need it change to Yellow color , and >90% i need it change to Red color.

Can some one share with me how to achieve ? On the Straight table i can display 3 color. base on above condition.

[#2]

Hi All

Can some one help me on this ...

Paul

[tresesco · Accepted solution]

Try like attached sample.

[#4]

Hi Sir

Many thank . now my chart is color ful.

I hope you can help me to make the RED color alway stay at 80% of the total sales.

Now when i change the  value from 11,000 , when diamension i select desc , the red color bar at 80% , when i change diamension to brand , the red color shift to about 95%.

See my enclosed QV doc.

Paul