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.