Cannot get the Static Minimum on the Axis Scale to change the scale's minimum value

[#1]

I've reduced my problem to a bare-bones sample, but still I cannot get the Static Min setting on a Chart / Axes / Scale to have any effect.

(1) Load some sample data:

USERS:
LOAD * INLINE [
ID, State, Age
1, AK, 18
2, AK, 20
3, AK, 22
4, AK, 19
5, AK, 23
6, AK, 21
7, CA, 28
8, CA, 30
9, CA, 32
10, CA, 29
11, CA, 33
12, CA, 31
];

(2) Create a simple Line Chart with:

Dimension = State

Expression =Avg(Age)

Display Options set to Normal Line

- when the Chart displays, its Y-Axis ranges from ages 0 to 35

( And incidentally, when I set the Scale > Static Max value to 50, the axis resets from 0 to 50. This is expected. )

HOWEVER,

when I set the Scale > Static Min to 14 there is NO EFFECT. The scale's minimum remains at zero ? This is unexpected... [:(]

Is there some other setting I must change to make the axis start at 14 and go to 50 ?

Has anyone else seen this behavior ?

[johnw · Accepted solution]

Yep, there's another setting. You need to remove the checkmark in "Forced 0" for the expression. That seems to be overriding the static minimum if the static minimum doesn't allow 0 to display, such as in this case.

[#3]

John Witherspoon wrote:
Yep, there's another setting. You need to remove the checkmark in "Forced 0" for the expression. That seems to be overriding the static minimum if the static minimum doesn't allow 0 to display, such as in this case. <div></div>

That did it John !

Thank you