Partager via


ChartSheet.RightAngleAxes Property

Gets or sets a value that indicates whether the Microsoft.Office.Tools.Excel.ChartSheet axes are at right angles, independent of chart rotation or elevation.

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 RightAngleAxes As Object
Object RightAngleAxes { get; set; }

Property Value

Type: System.Object
true if the Microsoft.Office.Tools.Excel.ChartSheet axes are at right angles, independent of chart rotation or elevation.

Remarks

Applies only to a 3-D line, column, or bar Microsoft.Office.Tools.Excel.ChartSheet.

If this property is true, the Perspective property is ignored.

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 DisplayDataTable()
    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.xl3DColumn
    Me.HasDataTable = True 
    Me.DataTable.HasBorderOutline = True 
End Sub
private void DisplayDataTable()
{
    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.xl3DColumn;

    this.HasDataTable = true;
    this.DataTable.HasBorderOutline = true;
}

.NET Framework Security

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace