ChartSheet.Perspective Property
Gets or sets the perspective for the 3-D Microsoft.Office.Tools.Excel.ChartSheet.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
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 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 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
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;
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.