Add colored scale to a bar chart

[alec1982]

Hi Guys,

I have a bar chart that shows horizontally scores 1 to 10 by city

I need to add colored circle or anything to reflect the value next to each dimension(bar)

Like if score = 8 and over then show green

if score between 5 and 8 show yellow and if score  is less than 5 then show in red.

I have the formula for the colors but I don't know what and how to ad the colors

If((IndexTotalScore)<5, RGB(255,100,100), If((IndexTotalScore)>=5 and (IndexTotalScore)<8, RGB(255,128,0), RGB(0,128,0)))

Any suggestions?

Thxs,

Alec

[#2]

[alec1982]

Hey Rebecca,

I have tried to do that but the chart that I have is a stacked bar chart and it will not look nice at all in this way.

Thank you so much!

Alec

[#4]

What does your data look like and what is your goal for it to look like? If you can post a sample file someone here can probably help.

[alec1982]

Hi,

The first chart is how my chart looks like and the second chart is what I am trying to do(Not exactly the same but I need to distinguish the bars based on the score. so either the left side colored circles or the left scale columns would work or any idea that you have might help.

Thxs for your help!

Alec

[avastani]

don't know if it is doable with a stacked chart, I faced a similar problem before. you might be better off creating it as a separate chart, hide the dimension values and place it close to it.

[#7]

I am not sure how you can get that effect with a stacked bar.  If you could live with accumulating all the values and showing as a single bar, then you could use a mini-chart in a straight table to get a similar interface.  See attached.