The final result

Figure 10 and Figure 11 below show the result of automatic maintenance of the axes limits.  Once the OK button in the dialog box is clicked, the chart will reflect the values in cells D1:E2.  As the cell values change, the chart will update automatically.

Figure 10

Since the data points are generated with a random generator, forcing a recalculation (F9) yields different numbers in A1:B6.  This causes the minimum and maximum values associated with the x- and y-axes to change (see cells D1:E2 in Figure 11 below).  The final effect is that the axes and the plotted data points change in the associated chart.

Figure 11