ChartSheetBase.Perspective Property

 

Gets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.

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

public int Perspective { get; set; }

Property Value

Type: System.Int32

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

This property is ignored if the RightAngleAxes property is true.

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;
}
Return to top
Show: