編輯

共用方式為


_Chart.GetChartElement(Int32, Int32, Int32, Int32, Int32) Method

Definition

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

public:
 void GetChartElement(int x, int y, int % ElementID, int % Arg1, int % Arg2);
public void GetChartElement (int x, int y, ref int ElementID, ref int Arg1, ref int Arg2);
Public Sub GetChartElement (x As Integer, y As Integer, ByRef ElementID As Integer, ByRef Arg1 As Integer, ByRef Arg2 As Integer)

Parameters

x
Int32

Required Integer. The X coordinate of the chart element.

y
Int32

Required Integer. The Y coordinate of the chart element.

ElementID
Int32

Required Integer. When the method returns, this argument contains the XlChartItem value of the chart element at the specified coordinates. For more information, see the Remarks section.

Arg1
Int32

Required Integer. When the method returns, this argument contains information related to the chart element. For more information, see the Remarks section.

Arg2
Int32

Required Integer. 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.

xlAxis AxisIndexAxisType
xlAxisTitle AxisIndexAxisType
xlDisplayUnitLabel AxisIndexAxisType
xlMajorGridlines AxisIndexAxisType
xlMinorGridlines AxisIndexAxisType
xlPivotChartDropZone DropZoneTypeNone
xlPivotChartFieldButton DropZoneTypePivotFieldIndex
xlDownBars GroupIndexNone
xlDropLines GroupIndexNone
xlHiLoLines GroupIndexNone
xlRadarAxisLabels GroupIndexNone
xlSeriesLines GroupIndexNone
xlUpBars GroupIndexNone
xlChartArea NoneNone
xlChartTitle NoneNone
xlCorners NoneNone
xlDataTable NoneNone
xlFloor NoneNone
xlLegend NoneNone
xlNothing NoneNone
xlPlotArea NoneNone
xlWalls NoneNone
xlDataLabel SeriesIndexPointIndex
xlErrorBars SeriesIndexNone
xlLegendEntry SeriesIndexNone
xlLegendKey SeriesIndexNone
xlSeries SeriesIndexPointIndex
xlShape ShapeIndexNone
xlTrendline SeriesIndexTrendLineIndex
xlXErrorBars SeriesIndexNone
xlYErrorBars SeriesIndexNone

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

AxisIndexSpecifies whether the axis is primary or secondary. Can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary.
AxisTypeSpecifies the axis type. Can be one of the following XlAxisType constants: xlCategory, xlSeriesAxis, or xlValue.
DropZoneTypeSpecifies the drop zone type: column, data, page, or row field. Can be one of the following XlPivotFieldOrientation constants: xlColumnField, xlDataField, xlPageField, or xlRowField. The column and row field constants specify the series and category fields respectively.
GroupIndexSpecifies the offset within the ChartGroups collection for a specific chart group.
PivotFieldIndexSpecifies the offset within the PivotFields collection for a specific column (series), data, page, or row (category) field. -1 if the drop zone type is xlDataField.
PointIndexSpecifies the offset within the Points collection for a specific point within a series. A value of –1 indicates that all data points are selected.
SeriesIndexSpecifies the offset within the Series collection for a specific series.
ShapeIndexSpecifies the offset within the Shapes collection for a specific shape.
TrendlineIndexSpecifies the offset within the Trendlines collection for a specific trendline within a series.

Applies to