ChartSheet.Rotation Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.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 ChartSheet.

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 ChartSheet (the rotation of the plot area around the z-axis, in degrees). 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. The default value is 20.

Examples

The following code example uses the Rotation property to display the current Microsoft.Office.Tools.Excel.ChartSheet without any rotation.

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

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

Remarks

Applies only to a 3-D Microsoft.Office.Tools.Excel.ChartSheet.

Applies to

Partager via