Re: how to set the min and max values of a guage chart in percentages
You cannot do this directly, so you have to work around the limitation. First negate the expression so that an increase is a decrease in your original expression:
=1 - <your current expression>
Make the chart from 0.97 - 1.0 but turn off the chart legend as it will display the negated value. On the presentation tab, Click Add for the Text in Chart option and add a 1.00 and 0.97 which you can re-position by holding down Shift+Control and dragging to the correct location for the axes scale. Or overlay with text objects to label the gauge.
This an example from a working model:
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein