Custom Legend Series

Hi All,

I am trying to show the score in Bar/Pie Chart. I want to have multiple legends in series say Excellent 90 - 100, Good 80 - 90, Fair 70 - 80, Poor 50 - 70 and so on…

If my Score falls on these range I want the bar to have same color as the legend. My question is it is possible to show these ranges in legends and dynamically change the color based on score? Please help.

Vijay K