Chart Arguments




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




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 Chart Groups collection for a specific chart group.
PivotFieldIndex
Specifies the offset within the Pivot Fields 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.