ChartEvents_BeforeDoubleClickEventHandler delegate
A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when an embedded chart is double-clicked, before the default double-click action.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Parameters
- ElementID
- Type: System.Int32
Required. The double-clicked object.
- Arg1
- Type: System.Int32
Depends on ElementID.
- Arg2
- Type: System.Int32
Depends on ElementID.
- Cancel
- Type: System.Boolean
Optional. False when the event occurs. If the event procedure sets this argument to True, the default double-click action isn't performed when the procedure is finished.
The following table shows the arguments associated with each ElementID.
ElementID | Arg1 | Arg2 |
|---|---|---|
xlAxis | AxisIndex | AxisType |
xlAxisTitle | AxisIndex | AxisType |
xlDisplayUnitLabel | AxisIndex | AxisType |
xlMajorGridlines | AxisIndex | AxisType |
xlMinorGridlines | AxisIndex | AxisType |
xlPivotChartDropZone | DropZoneType | None |
xlPivotChartFieldButton | DropZoneType | PivotFieldIndex |
xlDownBars | GroupIndex | None |
xlDropLines | GroupIndex | None |
xlHiLoLines | GroupIndex | None |
xlRadarAxisLabels | GroupIndex | None |
xlSeriesLines | GroupIndex | None |
xlUpBars | GroupIndex | None |
xlChartArea | None | None |
xlChartTitle | None | None |
xlCorners | None | None |
xlDataTable | None | None |
xlFloor | None | None |
xlLegend | None | None |
xlNothing | None | None |
xlPlotArea | None | None |
xlWalls | None | None |
xlDataLabel | SeriesIndex | PointIndex |
xlErrorBars | SeriesIndex | None |
xlLegendEntry | SeriesIndex | None |
xlLegendKey | SeriesIndex | None |
xlSeries | SeriesIndex | PointIndex |
xlTrendline | SeriesIndex | TrendLineIndex |
xlXErrorBars | SeriesIndex | None |
xlYErrorBars | SeriesIndex | None |
xlShape | ShapeIndex | None |
The following table describes the meaning of the arguments.
Argument | Description |
|---|---|
AxisIndex | Specifies whether the axis is primary or secondary. Can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. |
AxisType | Specifies the axis type. Can be one of the following XlAxisType constants: xlCategory, xlSeriesAxis, or xlValue. |
DropZoneType | Specifies 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. |
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. |
PointIndex | Specifies the offset within the Points collection for a specific point within a series. The value –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. |
The DoubleClick method doesn't cause this event to occur.
This event doesn't occur when the user double-clicks the border of a cell.