It fails because the default horizontal axis on an area chart is a categorical one and not numeric.
If you really meant for the horizontal axis to be numeric you will need to trick it by setting the axis to be Date type rather than text. Then the code would work.

Probably better to use numeric values rather than text.
.Axes(xlValue, xlPrimary).MinimumScale = 0  ' and not "0"