ChartGroups Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

A collection of all the ChartGroup objects in the specified chart.

public interface class ChartGroups : System::Collections::IEnumerable

[System.Runtime.InteropServices.Guid("0002085A-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ChartGroups : System.Collections.IEnumerable

Public Interface ChartGroups
Implements IEnumerable

Attributes: GuidAttribute InterfaceTypeAttribute

Implements: IEnumerable

Remarks

Each ChartGroup object represents one or more series plotted in a chart with the same format. A chart contains one or more chart groups, each chart group contains one or more series, and each series contains one or more points. For example, a single chart might contain both a line chart group, containing all the series plotted with the line chart format, and a bar chart group, containing all the series plotted with the bar chart format.

Use the ChartGroups method to return the ChartGroups collection. Use ChartGroups(index), where index is the chart-group index number, to return a single ChartGroup object. If the chart has been activated, you can use ActiveChart.

Because the index number for a particular chart group can change if the chart format used for that group is changed, it may be easier to use one of the named chart group shortcut methods to return a particular chart group. The PieGroups(Object) method returns the collection of pie chart groups in a chart, the LineGroups(Object) method returns the collection of line chart groups, and so on. Each of these methods can be used with an index number to return a single ChartGroup object, or without an index number to return a ChartGroups collection. The following chart group methods are available:

Properties

Application	Returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Count	Returns the number of objects in the collection. Read-only Integer.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Parent	Returns the parent object for the specified object. Read-only.

Methods

GetEnumerator()
Item(Object)	Returns a single object from a collection.

Applies to

Delen via