ChartSheetBase.Bar3DGroup Property

Gets a ChartGroup that represents the bar chart group on a 3-D 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 ReadOnly Property Bar3DGroup As ChartGroup

public ChartGroup Bar3DGroup { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.ChartGroup
A ChartGroup that represents the bar chart group on a 3-D Microsoft.Office.Tools.Excel.ChartSheetBase.

Examples

The following code example sets the current Microsoft.Office.Tools.Excel.ChartSheetBase to a 3-D bar chart and then uses the Bar3DGroup property to display drop lines in the chart.

Private Sub UseBar3DGroup()
    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.Bar3DGroup.HasDropLines = True 
End Sub

private void UseBar3DGroup()
{
    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.Bar3DGroup.HasDropLines = true;
}

.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