Chart.RightAngleAxes Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets a value that indicates whether the Chart control axes are at right angles, independent of chart rotation or elevation.

public:
 property System::Object ^ RightAngleAxes { System::Object ^ get(); void set(System::Object ^ value); };

public object RightAngleAxes { get; set; }

member this.RightAngleAxes : obj with get, set

Public Property RightAngleAxes As Object

Property Value

Object

true if the Chart control axes are at right angles, independent of chart rotation or elevation; otherwise, false.

Examples

The following code example creates a 3-D Chart and then changes the perspective by using the Perspective property. The example sets the RightAngleAxes property to false so that the perspective can be changed.

private void SetPerspective()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.RightAngleAxes = false;
    chart1.Perspective = 50;
}

Private Sub SetPerspective()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    Chart1.RightAngleAxes = False
    Chart1.Perspective = 50
End Sub

Remarks

Applies only to 3-D line, column, and bar charts. If this property is true, the Perspective property is ignored.

Applies to

Partager via