I'm using the following function to detect the size of the Y-axis in a
chart that is autoscaled by Excel:

Public Function MaxChartY()
MaxChartY =
Worksheets("CTest").ChartObjects.Item(1).Chart.Axe s(xlValue,
xlPrimary).MaximumScale
End Function

Then, in a cell on the "CTest" sheet, I enter:

=MaxChartY()

When first entered, the formula correctly shows the Y-axis maximum
value, but when data for the chart is changed and the Y-axis autoscales
accordingly, my MaxChartY formula does not update.

How can I get my formula to update automatically when the Y-axis
autoscales because of a change in the data feeding the chart?


--
ericsh
------------------------------------------------------------------------
ericsh's Profile: http://www.excelforum.com/member.php...o&userid=26149
View this thread: http://www.excelforum.com/showthread...hreadid=568574