Chart.Perspective Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 property int Perspective { int get(); void set(int value); };

public int Perspective { get; set; }

member this.Perspective : int with get, set

Public Property Perspective As Integer

Property Value

Int32

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

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 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;
}

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

Remarks

This property is ignored if the RightAngleAxes property is true.

Applies to

Partager via