Bullet chart color rules by amounts
I am using a bullet chart to compare Estimated (BOV) to Actual (Amount) amounts. I'd like to color the bars based on BOV vs. Amount: yellow if BOV <Amount, green if BOV =Amount, and red if BOV >Amount. Any idea where to start? I setup 3 beast mode calculations. I just can't figure out how to get them into the chart…
