Forum Discussion
Bar Chart with Variable Target Line
Hi All, I have a hopefulyl a simple problem.... I have 50 Locatons, these are broken into 4 Regions, and 6 Business Divisions. I have the actual performance calcualted and working for each...
Hi Audience,
I am trying to achieve Bar chart with fixed Target Line
Target Lin Value: 14.5%
Bar Chart Values: Variable keeps on changing eg: 4% 8% 16% 20% 32% 40 % max is 100 %
Need to display
If Below 14.5 % Green Bar
Above 14.6 % Red bar as it has reached above the target values i have Data Colors and Rules and set for that particular column it does not work need your suggestions and inputs.
Rule: If value >= 0 percent and <= 14.5 Percent then Green
If value >==14.6 percent and <= 100 percent then Red
It doe not work color does not change with the Rules applied. Need you help extremly stuck for a week now.