Chart.Rotation 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 the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).

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

public object Rotation { get; set; }

member this.Rotation : obj with get, set

Public Property Rotation As Object

Property Value

Object

The rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees). The default value is 20.

Examples

The following code example creates a 3-D Chart and then changes the rotation by using the Rotation property.

private void SetRotation()
{
    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.Rotation = 40;
}

Private Sub SetRotation()
    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.Rotation = 40
End Sub

Remarks

The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. Applies only to 3-D charts.

Applies to

Partager via