Share via


Chart.Perspective Property

Gets or sets the perspective for the 3-D chart view.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Property Perspective As Integer
int Perspective { get; set; }

Property Value

Type: System.Int32
The perspective for the 3-D chart view. Must be between 0 and 100.

Remarks

This property is ignored if the RightAngleAxes property is true.

Examples

The following code example creates a 3-D Chart and then changes the perspective to 50 by using the Perspective property. The example sets the RightAngleAxes property to false before setting the Perspective property.

Private Sub SetPerspective()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    Chart1.RightAngleAxes = False
    Chart1.Perspective = 50
End Sub
private void SetPerspective()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.RightAngleAxes = false;
    chart1.Perspective = 50;
}

.NET Framework Security

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace