Programming Excel with VBA and .NET

Name

plotarea.InsideHeight

Synopsis

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 Sub