I have a gauge chart with its boundries set for when all data is being comparied, but when I drill down to a month level the banding becomes useless. It is always in the Green. If I set it up with a formula where the min boundry is 10% less than the total and the max is 10% more than the total the needle never moves. How has the community dealt with this problem?
