Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

ChartSheetBase.Area3DGroup Property

Gets a ChartGroup that represents the area 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)

public ChartGroup Area3DGroup { get; }

Property Value

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

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

private void UseArea3DGroup()
{
    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.xl3DArea;

    this.Area3DGroup.HasDropLines = true;
}

Show:
© 2015 Microsoft