The chart usually recalculates and redraws the axes whenever data changes. The bounds of any axis can be fixed so that it is not recalculated when data changes. For the X and Y-axes, a portion of data can be framed by setting axis bounds inside the data bounds.
Use the Axes Min and Max properties to fix the minimum or maximum axis extent at a particular value. AutoMax and AutoMin properties allow the chart to automatically determine axis bounds based on the data bounds. These properties are located on the Chart3DAxis Collection Editor. This editor can be accessed by:
The Z-axis minimum/maximum cannot be set inside the Z-range of the data. If a fixed extent exists for the Z-axis and a subsequent data change puts the range outside of the axis, the chart sets the Z-axis AutoMax and AutoMin properties so that its extent is recalculated.
The X-axis and Y-axis minimum/maximum cannot be set to a location that does not coincide with a line of data. The values are always adjusted upwards to coincide.