Megosztás a következőn keresztül:


Chart.RightAngleAxes Property

Gets or sets a value that indicates whether the Chart control 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
Object RightAngleAxes { get; set; }

Property Value

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

Remarks

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

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 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
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;
}

.NET Framework Security

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace