XlChartItem enumeration (Excel)

Specifies the type of the chart item.

Name Value Description
xlAxis 21 Axis.
xlAxisTitle 17 Axis title.
xlChartArea 2 Chart area.
xlChartTitle 4 Chart title.
xlCorners 6 Corners.
xlDataLabel 0 Data label.
xlDataTable 7 Data table.
xlDisplayUnitLabel 30 Display unit label.
xlDownBars 20 Down bars.
xlDropLines 26 Drop lines.
xlErrorBars 9 Error bars.
xlFloor 23 Floor.
xlHiLoLines 25 HiLo lines.
xlLeaderLines 29 Leader lines.
xlLegend 24 Legend.
xlLegendEntry 12 Legend entry.
xlLegendKey 13 Legend key.
xlMajorGridlines 15 Major gridlines.
xlMinorGridlines 16 Minor gridlines.
xlNothing 28 Nothing.
xlPivotChartDropZone 32 PivotChart drop zone.
xlPivotChartFieldButton 31 PivotChart field button.
xlPlotArea 19 Plot area.
xlRadarAxisLabels 27 Radar axis labels.
xlSeries 3 Series.
xlSeriesLines 22 Series lines.
xlShape 14 Shape.
xlTrendline 8 Trend line.
xlUpBars 18 Up bars.
xlWalls 5 Walls.
xlXErrorBars 10 X error bars.
xlYErrorBars 11 Y error bars.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.