Corners Members

Use the Chart object’s Corners property to get a reference to this object. The Corners object has the following members:

Application
Creator
Name
Parent
Select

Only 3-D charts have a Corners object, and about the only thing you can do with Corners is to select them so the user can click and drag them to rotate the chart, as shown here:

Sub SelectCorners ( )
    Dim chrt As Chart
    ' Get the chart.
    Set chrt = ActiveChart
    ' Make it a 3-D chart
    chrt.ChartType = xl3DArea
    ' Select the corners.
    chrt.Corners.Select
    ' Now you can drag the corners to rotate the chart...
End Sub

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.