ChartSheet.Perspective Property

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assemblies:

Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets or sets the perspective for the 3-D ChartSheet.

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 uses the Perspective property to set the view perspective of the current Microsoft.Office.Tools.Excel.ChartSheet to 45 degrees. The example sets the RightAngleAxes property to false before setting the Perspective property.

private void AdjustPerspective()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DBarClustered; 

    this.RightAngleAxes = false;
    this.Perspective = 45;
}

Private Sub AdjustPerspective()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DBarClustered
    Me.RightAngleAxes = False
    Me.Perspective = 45
End Sub

Remarks

This property is ignored if the RightAngleAxes property is true.