Udostępnij za pośrednictwem


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
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Property RightAngleAxes As Object
    Get
    Set
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