Returns information about the chart element at specified x-coordinate and y-coordinates. This method is unusual in that you specify values for only the first two arguments. Microsoft Office PowerPoint fills in the other arguments, and your code should examine those values when the method returns.

Syntax

expression.GetChartElement(X, Y, ElementID, Arg1, Arg2)

expression An expression that returns a Chart object.

Parameters

Name Required/Optional Data Type Description
X Required Long The x-coordinate of the chart element.
Y Required Long The y-coordinate of the chart element.
ElementID Required Long When the method returns, this argument contains the PpChartItem value of the chart element at the specified coordinates. For more information, see the "Remarks" section.
Arg1 Required Long When the method returns, this argument contains information related to the chart element. For more information, see the "Remarks" section.
Arg2 Required Long When the method returns, this argument contains information related to the chart element. For more information, see the "Remarks" section.

Remarks

The value of ElementID after the method returns determines whether Arg1 and Arg2 contain any information, as shown in the following table.

ElementID Constant Constant Value Arg1 Arg2
ppAxis 21 AxisIndex AxisType
ppAxisTitle 17 AxisIndex AxisType
ppDisplayUnitLabel 30 AxisIndex AxisType
ppMajorGridlines 15 AxisIndex AxisType
ppMinorGridlines 16 AxisIndex AxisType
ppPivotChartDropZone 32 DropZoneType None
ppPivotChartFieldButton 31 DropZoneType PivotFieldIndex
ppDownBars 20 GroupIndex None
ppDropLines 26 GroupIndex None
ppHiLoLines 25 GroupIndex None
ppRadarAxisLabels 27 GroupIndex None
ppSeriesLines 22 GroupIndex None
ppUpBars 18 GroupIndex None
ppChartArea 2 None None
ppChartTitle 4 None None
ppCorners 6 None None
ppDataTable 7 None None
ppFloor 23 None None
ppLeaderLines 29 None None
ppLegend 24 None None
ppNothing 28 None None
ppPlotArea 19 None None
ppWalls 5 None None
ppDataLabel 7 SeriesIndex PointIndex
ppErrorBars 9 SeriesIndex None
ppLegendEntry 12 SeriesIndex None
ppLegendKey 13 SeriesIndex None
ppSeries 3 SeriesIndex PointIndex
ppShape 14 ShapeIndex None
ppTrendline 8 SeriesIndex TrendLineIndex
ppXErrorBars 10 SeriesIndex None
ppYErrorBars 11 SeriesIndex None

The following table describes the meaning of Arg1 and Arg2 after the method returns.

Argument Description
AxisIndex Specifies whether the axis is primary or secondary. Can be one of the following PpAxisGroup constants: ppPrimary or ppSecondary.
AxisType Specifies the axis type. Can be one of the following PpAxisType constants: ppCategory, ppSeriesAxis, or ppValue.
DropZoneType Specifies the drop zone type: column, data, page, or row field. Can be one of the following PpPivotFieldOrientation constants: ppColumnField, ppDataField, ppPageField, or ppRowField. The column and row field constants specify the series and category fields, respectively.
GroupIndex Specifies the offset within the ChartGroups collection for a specific chart group.
PivotFieldIndex Specifies the offset within the PivotFields collection for a specific column (series), data, page, or row (category) field. -1 if the drop zone type is ppDataField.
PointIndex Specifies the offset within the Points collection for a specific point within a series. A value of - 1 indicates that all data points are selected.
SeriesIndex Specifies the offset within the Series collection for a specific series.
ShapeIndex Specifies the offset within the Shapes collection for a specific shape.
TrendlineIndex Specifies the offset within the Trendlines collection for a specific trendline within a series.

Example

This example warns the user if she moves the mouse over the chart legend.

Visual Basic for Applications 
Private Sub Chart_MouseMove(ByVal Button As Long, _ ByVal Shift As Long, ByVal X As Long, ByVal Y As Long) Dim IDNum As Long Dim a As Long Dim b As Long ActiveChart.GetChartElement X, Y, IDNum, a, b If IDNum = ppLegendEntry Then _ MsgBox "WARNING: Move away from the legend" End Sub

See also: