Share via

ChartSheetBase.BarShape Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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

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.ChartSheetBase 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