ChartSheetBase.Perspective Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.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 ChartSheetBase.

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.ChartSheetBase 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.

Applies to

Share via