Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Chart.Rotation Property

Gets or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public Object Rotation { get; set; }

Property Value

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.

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.

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

Show:
© 2015 Microsoft