ChartSheetBase.BarShape Property

Gets or sets the shape used with the 3-D bar or column Microsoft.Office.Tools.Excel.ChartSheetBase.

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

Syntax

'Declaration
Public Property BarShape As XlBarShape

public XlBarShape BarShape { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.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 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

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

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace