I have two segments in my gauge chart-red followed by green. I want all the negative values to be in the red segment and the positive ones in green. I have a lot of permutations so can't use a minimum or maximum value (there are too many to figure out the smallest or the biggest).
I know about auto width segments and lower bounds but just can't get the numbers right...if lower bound for green is zero, need something for red too (ideally the lowest value possibly of that expression) but don't know the syntax for it
