ChartSheet.BarShape Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets or sets the shape used with the 3-D bar or column ChartSheet.

public:
 property Microsoft::Office::Interop::Excel::XlBarShape BarShape { Microsoft::Office::Interop::Excel::XlBarShape get(); void set(Microsoft::Office::Interop::Excel::XlBarShape value); };
public Microsoft.Office.Interop.Excel.XlBarShape BarShape { get; set; }
member this.BarShape : Microsoft.Office.Interop.Excel.XlBarShape with get, set
Public Property BarShape As XlBarShape

Property Value

XlBarShape

One of the XlBarShape values.

Examples

The following code example uses the BarShape property of the current Microsoft.Office.Tools.Excel.ChartSheet to display the bars as cylinders.

private void SetBarShape()
{
    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.BarShape = Excel.XlBarShape.xlCylinder;
}

Private Sub SetBarShape()
    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.BarShape = Excel.XlBarShape.xlCylinder
End Sub

Applies to