Bar Chart Help

[lockematthewp]

I currently have only two fields, TotalDataPoints and BadDataPoint. I want my bar chart to have a dimension of integers from 1 to TotalDataPoints (=ValueLoop(1,TotalDataPoints,1)). My only expression is =1 so that they are all equal length bars. I have this done so far (See pic below). I would like to change the color of bars that have a dimension value equal to BadDataPoint. For example, if I have BadDataPoints of 10,25, and 40, then the corresponding bars would be colored red. I would really appreciate any help with this.

[bharathadde]

Use condition on background color of expression.(which is under + sign of expression)

Do you have any criteria or flag column that would determine BadDataPoints??

For suppose flag=1 is for BadDataPoints

put a condition like below in background color

= if(flag=1,red(),green())

[lockematthewp]

I am now getting closer to my desired result. Unfortunately, there are twice as many bars in the chart as I need. I believe this is because I am using two dimensions. The only expression is still =1. Any one know how to fix this?