Share via


ChartSheet.Perspective Property (2007 System)

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

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Property Perspective As Integer
'Usage
Dim instance As ChartSheet 
Dim value As Integer 

value = instance.Perspective

instance.Perspective = value
[BrowsableAttribute(false)]
public int Perspective { get; set; }
[BrowsableAttribute(false)]
public:
property int Perspective {
    int get ();
    void set (int value);
}
public function get Perspective () : int 
public function set Perspective (value : int)

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

See Also

Reference

ChartSheet Class

ChartSheet Members

Microsoft.Office.Tools.Excel Namespace