Lays out a chart, forcing recalculation of automatic values.
Syntax
object.Layout
The object placeholder represents an object expression that evaluates to an object in the Applies To list.
Remarks
A chart is laid out the first time it is drawn. When any chart settings change, the chart is again laid out at the next draw. There are a number of settings the chart calculates, such as the axis minimum and maximum values, based on the chart type or some other setting. These values are not determined until the chart is laid out. If you attempt to "get" these automatic values before the chart is properly laid out, they will not reflect the new values.