April 2006
Beginner
1114 pages
98h 16m
English
plotarea.InsideHeight
Returns the height of the area on which the series is plotted. The total plot area is larger than the inside dimensions used to plot series, as demonstrated by the following code:
Sub CompareDimensions( )
Dim chrt As Chart, pa As PlotArea
' Get the chart.
Set chrt = ActiveChart
' Make it a line chart
chrt.ChartType = xlLine
' Get the plot area.
Set pa = chrt.PlotArea
' Show difference between inside and standard dimensions.
Debug.Print pa.InsideLeft, pa.InsideTop, pa.InsideHeight, pa.InsideWidth
Debug.Print pa.Left, pa.Top, pa.Height, pa.Width
End SubRead now
Unlock full access