XL: Errors Changing Chart Axis Value Scale in Macro

• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Macintosh, versions 5.0, 5.0a

SYMPTOMS

When you set the axis values on a chart through a macro using the MimimumScale and/or MaximumScale properties, you may receive the following error message:

   Run-Time Error 1005:
   "Maximum axis value must be greater than minimum axis value. "

CAUSE

The error message may appear if the following is true:

• The values are calculated in the macro.

  -and-

• The value that you are setting is outside the range of the current values.

RESOLUTION

To resolve the error message, reverse the order of the commands in the macro. For example, if you are setting the low (minimum) value first and that is the line of code that is generating the error message, set the high (maximum) value first. If you are setting the high (maximum) value first and that is the line of code that is generating the error message, set the low (minimum) value first.

REFERENCES

For more information about changing the value axis scale, click the Search button in Help and type:

   scale