Charts
| xlAxisCrosses | Specifies the point on the specified axis where the other axis crosses. |
| xlAxisGroup | Specifies the type of axis group. |
| xlAxisType | Specifies the axis type. |
| xlBinsType | Specifies the values passed to and returned from the ChartGroup.BinsType property. |
| xlCategoryType | Specifies the type of the category axis. |
| xlChartGallery | Specifies a chart gallery. |
| xlChartItem | Specifies the type of the chart item. |
| xlChartLocation | Specifies where to relocate a chart. |
| xlChartPicturePlacement | Specifies the placement of a user-selected picture on a bar in a 3-D bar or column. |
| xlChartPictureType | Specifies how pictures are displayed on a column, bar picture chart, or legend key. |
| xlChartSplitType | Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. |
| xlChartType | Specifies the chart type. |
| xlDataLabelPosition | Specifies where the data label is positioned. |
| xlDataLabelSeparator | Specifies the separator used with data labels. |
| xlDataLabelsType | Specifies the type of data label to apply. |
| xlDataSeriesDate | Specifies the type of date to apply to a data series. |
| xlDataSeriesType | Specifies the data series to create. |
| xlDisplayBlanksAs | Specifies how blank cells are plotted on a chart. |
| xlDisplayUnit | Specifies the display unit label for an axis. |
| xlEndStyleCap | Specifies the end style for error bars. |
| xlErrorBarDirection | Specifies which axis values are to receive error bars. |
| xlErrorBarInclude | Specifies which error bar parts to include. |
| xlErrorBarType | Specifies the range marked by error bars. |
| xlGeoMappingLevel | Specifies the geography mapping level for a series within a chart group. |
| xlGeoProjectionType | Specifies the geography projection type for a series within the chart group. |
| xlLegendPosition | Specifies the position of the legend on a chart. |
| xlMarkerStyle | Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart. |
| xlObjectSize | Specifies the way a chart is scaled to fit on a page. |
| xlPieSliceIndex | Specifies which position on the slice to return the coordinate of. |
| xlPieSliceLocation | Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area. |
| xlRegionLabelOptions | Specifies the region labelling behavior for a series within the chart group. |
| xlRowCol | Specifies whether the values corresponding to a particular data series are in rows or columns. |
| xlScaleType | Specifies the scale type of the value axis. |
| xlTickLabelOrientation | Specifies the text orientation for tick-mark labels. |
| xlTickLabelPosition | Specifies the position of tick-mark labels on the specified axis. |
| xlTickMark | Specifies the position of major and minor tick marks for an axis. |
| xlTimeUnit | Specifies unit of time for chart axis and data series. |
| xlTrendlineType | Specifies how the trendline that smoothes out fluctuations in the data is calculated. |
| xlAxisCrosses Specifies the point on the specified axis where the other axis crosses. |
| xlAxisGroup Specifies the type of axis group. |
| xlAxisType Specifies the axis type. |
| xlBinsType Specifies the values passed to and returned from the ChartGroup.BinsType property. |
| xlCategoryType Specifies the type of the category axis. |
| xlChartGallery Specifies a chart gallery. |
| xlChartItem Specifies the type of the chart item. |
| xlChartLocation Specifies where to relocate a chart. |
| xlChartPicturePlacement Specifies the placement of a user-selected picture on a bar in a 3-D bar or column. |
| xlChartPictureType Specifies how pictures are displayed on a column, bar picture chart, or legend key. |
| xlChartSplitType Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. |
| xlChartType Specifies the chart type. |
| xlDataLabelPosition Specifies where the data label is positioned. |
| xlDataLabelSeparator Specifies the separator used with data labels. |
| xlDataLabelsType Specifies the type of data label to apply. |
| xlDataSeriesDate Specifies the type of date to apply to a data series. |
| xlDataSeriesType Specifies the data series to create. |
| xlDisplayBlanksAs Specifies how blank cells are plotted on a chart. |
| xlDisplayUnit Specifies the display unit label for an axis. |
| xlEndStyleCap Specifies the end style for error bars. |
| xlErrorBarDirection Specifies which axis values are to receive error bars. |
| xlErrorBarInclude Specifies which error bar parts to include. |
| xlErrorBarType Specifies the range marked by error bars. |
| xlGeoMappingLevel Specifies the geography mapping level for a series within a chart group. |
| xlGeoProjectionType Specifies the geography projection type for a series within the chart group. |
| xlLegendPosition Specifies the position of the legend on a chart. |
| xlMarkerStyle Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart. |
| xlObjectSize Specifies the way a chart is scaled to fit on a page. |
| xlPieSliceIndex Specifies which position on the slice to return the coordinate of. |
| xlPieSliceLocation Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area. |
| xlRegionLabelOptions Specifies the region labelling behavior for a series within the chart group. |
| xlRowCol Specifies whether the values corresponding to a particular data series are in rows or columns. |
| xlScaleType Specifies the scale type of the value axis. |
| xlTickLabelOrientation Specifies the text orientation for tick-mark labels. |
| xlTickLabelPosition Specifies the position of tick-mark labels on the specified axis. |
| xlTickMark Specifies the position of major and minor tick marks for an axis. |
| xlTimeUnit Specifies unit of time for chart axis and data series. |
| xlTrendlineType Specifies how the trendline that smoothes out fluctuations in the data is calculated. |
xlAxisCrosses |
| Specifies the point on the specified axis where the other axis crosses. |
| xlAxisCrossesAutomatic | Excel sets the axis crossing point (-4105) |
| xlAxisCrossesCustom | The CrossesAt Property specifies the axis crossing point (-4114) |
| xlAxisCrossesMaximum | The axis crosses at the maximum value (2) |
| xlAxisCrossesMinimum | The axis crosses at the minimum value (4) |
| xlAxisCrossesAutomatic |
| Excel sets the axis crossing point (-4105) |
| xlAxisCrossesCustom |
| The CrossesAt Property specifies the axis crossing point (-4114) |
| xlAxisCrossesMaximum |
| The axis crosses at the maximum value (2) |
| xlAxisCrossesMinimum |
| The axis crosses at the minimum value (4) |
xlAxisGroup |
| Specifies the type of axis group. |
| xlPrimary | Primary axis group (1) |
| xlSecondary | Secondary axis group (2) |
| xlPrimary |
| Primary axis group (1) |
| xlSecondary |
| Secondary axis group (2) |
xlAxisType |
| Specifies the axis type. |
| xlCategory | Axis displays categories (1) |
| xlSeriesAxis | Axis displays data series (3) |
| xlValue | Axis displays values (2) |
| xlCategory |
| Axis displays categories (1) |
| xlSeriesAxis |
| Axis displays data series (3) |
| xlValue |
| Axis displays values (2) |
| REMARKS |
| * The xlSeriesAxis is only applicable to Surface Charts. |
xlBinsType |
| Specifies the values passed to and returned from the ChartGroup.BinsType property. |
| xlBinsTypeAutomatic | Sets the bins type automatically (0) |
| xlBinsTypeBinCount | Sets bins type by count (4) |
| xlBinsTypeBinSize | Sets bins type by size (3) |
| xlBinsTypeCategorical | Sets bins type by category (1) |
| xlBinsTypeManual | Sets bins type manually (2) |
| xlBinsTypeAutomatic |
| Sets the bins type automatically (0) |
| xlBinsTypeBinCount |
| Sets bins type by count (4) |
| xlBinsTypeBinSize |
| Sets bins type by size (3) |
| xlBinsTypeCategorical |
| Sets bins type by category (1) |
| xlBinsTypeManual |
| Sets bins type manually (2) |
| REMARKS |
| * Added in 2016. |
xlCategoryType |
| Specifies the type of the category axis. |
| xlAutomaticScale | Excel controls the category type (-4105) |
| xlCategoryScale | Axis groups data by a list of categories (2) |
| xlTimeScale | Axis groups data on a time scale (3) |
| xlAutomaticScale |
| Excel controls the category type (-4105) |
| xlCategoryScale |
| Axis groups data by a list of categories (2) |
| xlTimeScale |
| Axis groups data on a time scale (3) |
xlChartGallery |
| Specifies a chart gallery. |
| xlAnyGallery | Uses custom chart formats from either xl8galry.xls or xlsurgal.xls (23) |
| xlBuiltIn | Uses custom chart formats from xl8galry.xls (21) |
| xlUserDefined | Uses custom chart formats from xlsurgal.xls (22) |
| xlAnyGallery |
| Uses custom chart formats from either xl8galry.xls or xlsurgal.xls (23) |
| xlBuiltIn |
| Uses custom chart formats from xl8galry.xls (21) |
| xlUserDefined |
| Uses custom chart formats from xlsurgal.xls (22) |
xlChartItem |
| Specifies the type of the chart item. |
| xlAxis | Axis (21) |
| xlAxisTitle | Axis title (17) |
| xlChartArea | Chart area (2) |
| xlChartTitle | Chart title (4) |
| xlCorners | Corners (6) |
| xlDataLabel | Data label (0) |
| xlDataTable | Data table (7) |
| xlDisplayUnitLabel | Display unit label (30) |
| xlDownBars | Down bars (20) |
| xlDropLines | Drop lines (26) |
| xlErrorBars | Error bars (9) |
| xlFloor | Floor (23) |
| xlHiLoLines | High low lines (25) |
| xlLeaderLines | Leader lines (29) |
| xlLegend | Legend (24) |
| xlLegendEntry | Legend entry (12) |
| xlLegendKey | Legend key (13) |
| xlMajorGridlines | Major gridlines (15) |
| xlMinorGridlines | Minor gridlines (16) |
| xlNothing | Nothing (28) |
| xlPivotChartDropZone | Pivot chart drop zone (32) |
| xlPivotChartFieldButton | Pivot chart field button (31) |
| xlPlotArea | Plot area (19) |
| xlRadarAxisLabels | Radar axis labels (27) |
| xlSeries | Series (3) |
| xlSeriesLines | Series lines (22) |
| xlShape | Shape (14) |
| xlTrendline | Trendline (8) |
| xlUpBars | Up bars (18) |
| xlWalls | Walls (5) |
| xlXErrorBars | X error bars (10) |
| xlYErrorBars | Y error bars (11) |
| xlAxis |
| Axis (21) |
| xlAxisTitle |
| Axis title (17) |
| xlChartArea |
| Chart area (2) |
| xlChartTitle |
| Chart title (4) |
| xlCorners |
| Corners (6) |
| xlDataLabel |
| Data label (0) |
| xlDataTable |
| Data table (7) |
| xlDisplayUnitLabel |
| Display unit label (30) |
| xlDownBars |
| Down bars (20) |
| xlDropLines |
| Drop lines (26) |
| xlErrorBars |
| Error bars (9) |
| xlFloor |
| Floor (23) |
| xlHiLoLines |
| High low lines (25) |
| xlLeaderLines |
| Leader lines (29) |
| xlLegend |
| Legend (24) |
| xlLegendEntry |
| Legend entry (12) |
| xlLegendKey |
| Legend key (13) |
| xlMajorGridlines |
| Major gridlines (15) |
| xlMinorGridlines |
| Minor gridlines (16) |
| xlNothing |
| Nothing (28) |
| xlPivotChartDropZone |
| Pivot chart drop zone (32) |
| xlPivotChartFieldButton |
| Pivot chart field button (31) |
| xlPlotArea |
| Plot area (19) |
| xlRadarAxisLabels |
| Radar axis labels (27) |
| xlSeries |
| Series (3) |
| xlSeriesLines |
| Series lines (22) |
| xlShape |
| Shape (14) |
| xlTrendline |
| Trendline (8) |
| xlUpBars |
| Up bars (18) |
| xlWalls |
| Walls (5) |
| xlXErrorBars |
| X error bars (10) |
| xlYErrorBars |
| Y error bars (11) |
xlChartLocation |
| Specifies where to relocate a chart. |
| xlLocationAsNewSheet | Chart is moved to a new sheet (1) |
| xlLocationAsObject | Chart is to be embedded in an existing sheet (2) |
| xlLocationAutomatic | Excel controls chart location (3) |
| xlLocationAsNewSheet |
| Chart is moved to a new sheet (1) |
| xlLocationAsObject |
| Chart is to be embedded in an existing sheet (2) |
| xlLocationAutomatic |
| Excel controls chart location (3) |
xlChartPicturePlacement |
| Specifies the placement of a user-selected picture on a bar in a 3-D bar or column. |
| xlAllFaces | Display on all faces (7) |
| xlEnd | Display on end (2) |
| xlEndSides | Display on end and sides (3) |
| xlFront | Display on front (4) |
| xlFrontEnd | Display on front and end (6) |
| xlFrontSides | Display on front and sides (5) |
| xlSides | Display on sides (1) |
| xlAllFaces |
| Display on all faces (7) |
| xlEnd |
| Display on end (2) |
| xlEndSides |
| Display on end and sides (3) |
| xlFront |
| Display on front (4) |
| xlFrontEnd |
| Display on front and end (6) |
| xlFrontSides |
| Display on front and sides (5) |
| xlSides |
| Display on sides (1) |
xlChartPictureType |
| Specifies how pictures are displayed on a column, bar picture chart, or legend key. |
| xlStack | Picture is sized to repeat a maximum of 15 times in the longest stacked bar (2) |
| xlStackScale | Picture is sized to a specified number of units and repeated the length of the bar (3) |
| xlStretch | Picture is stretched the full length of the stacked bar (1) |
| xlStack |
| Picture is sized to repeat a maximum of 15 times in the longest stacked bar (2) |
| xlStackScale |
| Picture is sized to a specified number of units and repeated the length of the bar (3) |
| xlStretch |
| Picture is stretched the full length of the stacked bar (1) |
xlChartSplitType |
| Specifies the values displayed in the second chart in a pie chart or a bar of pie chart. |
| xlSplitByCustomSplit | Arbitrary slides are displayed in the second chart (4) |
| xlSplitByPercentValue | Second chart displays values less than some percentage of the total value The percentage is specified by the splitvalue property (3) |
| xlSplitByPosition | Second chart displays the smallest values in the data series The number of values to display is specified by the SplitValue property (1) |
| xlSplitByValue | Second chart displays values less than the value specified by the SplitValue property (2) |
| xlSplitByCustomSplit |
| Arbitrary slides are displayed in the second chart (4) |
| xlSplitByPercentValue |
| Second chart displays values less than some percentage of the total value The percentage is specified by the splitvalue property (3) |
| xlSplitByPosition |
| Second chart displays the smallest values in the data series The number of values to display is specified by the SplitValue property (1) |
| xlSplitByValue |
| Second chart displays values less than the value specified by the SplitValue property (2) |
xlChartType |
| Specifies the chart type. |
| xl3DArea | 3D Area chart type (-4098) |
| xl3DAreaStacked | 3D Area Stacked chart type (78) |
| xl3DAreaStacked100 | 3D Area Stacked 100 chart type (79) |
| xl3DBarClustered | 3D Bar Clustered chart type (60) |
| xl3DBarStacked | 3D Bar Stacked chart type (61) |
| xl3DBarStacked100 | 3D Bar Stacked 100 chart type (62) |
| xl3DColumn | 3D Column chart type (-4100) |
| xl3DColumnClustered | 3D Column Clustered chart type (54) |
| xl3DColumnStacked | 3D Column Stacked chart type (55) |
| xl3DColumnStacked100 | 3D Column Stacked 100 chart type (56) |
| xl3DLine | 3D Line chart type (-4101) |
| xl3DPie | 3D Pie chart type (-4102) |
| xl3DPieExploded | 3D Pie Exploded chart type (70) |
| xlArea | Area chart type (1) |
| xlAreaStacked | Area Stacked chart type (76) |
| xlAreaStacked100 | Area Stacked 100 chart type (77) |
| xlBarClustered | Bar Clustered chart type (57) |
| xlBarOfPie | Bar of Pie chart type (71) |
| xlBarStacked | Bar Stacked chart type (58) |
| xlBarStacked100 | Bar Stacked 100 chart type (59) |
| xlBoxWhisker | (Added in 2016) Box Whisker chart type (121) |
| xlBubble | Bubble chart type (15) |
| xlBubble3DEffect | 3D Bubble chart type (87) |
| xlColumnClustered | Column Clustered chart type (51) |
| xlColumnStacked | Column Stacked chart type (52) |
| xlColumnStacked100 | Column Stacked 100 chart type (53) |
| xlConeBarClustered | Bar Clustered Cone chart type (102) |
| xlConeBarStacked | Bar Stacked Cone chart type (103) |
| xlConeBarStacked100 | Bar Stacked 100 Cone chart type (104) |
| xlConeCol | Column Cone chart type (105) |
| xlConeColClustered | Column Clustered Cone chart type (99) |
| xlConeColStacked | Column Stacked Cone chart type (100) |
| xlConeColStacked100 | Column Stacked 100 chart type (101) |
| xlCylinderBarClustered | Bar Clustered Cylinder chart type (95) |
| xlCylinderBarStacked | Bar Stacked Cylinder chart type (96) |
| xlCylinderBarStacked100 | Bar Stacked 100 Cylinder chart type (97) |
| xlCylinderCol | Column Cylinder chart type (98) |
| xlCylinderColClustered | Column Clustered Cyliner chart type (92) |
| xlCylinderColStacked | Column Stacked Cylinder chart type (93) |
| xlCylinderColStacked100 | Column Stacked 100 Cylinder chart type (94) |
| xlDoughnut | Doughnut chart type (-4120) |
| xlDoughnutExploded | Doughnut Exploded chart type (80) |
| xlFunnel | (Added in 2019) Funnel chart type (123) |
| xlHistogram | (Added in 2016) Histogram chart type (118) |
| xlLine | Line chart type (4) |
| xlLineMarkers | Line with Markers chart type (65) |
| xlLineMarkersStacked | Line Stacked with Markers chart type (66) |
| xlLineMarkersStacked100 | Line Stacked 100 with Markers chart type (67) |
| xlLineStacked | Line Stacked chart type (63) |
| xlLineStacked100 | Line Stacked 100 chart type (64) |
| xlPareto | (Added in 2016) Pareto chart type (122) |
| xlPie | Pie chart type (5) |
| xlPieExploded | (Moved in 2013) Pie Exploded chart type (69) |
| xlPieOfPie | Pie of Pie chart type (68) |
| xlPyramidBarClustered | Bar Clustered Pyramid chart type (109) |
| xlPyramidBarStacked | Bar Stacked Pyramid chart type (110) |
| xlPyramidBarStacked100 | Bar Stacked 100 Pyramid chart type (111) |
| xlPyramidCol | Column Pyramid chart type 112 |
| xlPyramidColClustered | Column Clustered Pyramid chart type (106) |
| xlPyramidColStacked | Column Stacked Pyramid chart type (107) |
| xlPyramidColStacked100 | Column Stacked 100 Pyramid chart type (108) |
| xlRadar | Radar chart type (-4151) |
| xlRadarFilled | Radar Filled chart type (82) |
| xlRadarMarkers | Radar with Markers chart type (81) |
| xlRegionMap | (Added in 2019) Map chart type (140) |
| xlStockHLC | Stock High Low Close chart type (88) |
| xlStockOHLC | Stock Open High Low Close chart type (89) |
| xlStockVHLC | Stock Volume High Low Close chart type (90) |
| xlStockVOHLC | Stock Volume Open High Low Close chart type (91) |
| xlSunburst | (Added in 2016) Sunburst chart type (120) |
| xlSurface | Surface chart type (83) |
| xlSurfaceTopView | Surface Top View chart type (85) |
| xlSurfaceTopViewWireframe | Surface Top View Wireframe chart type (86) |
| xlSurfaceWireframe | Surface Wireframe chart type (84) |
| xlTreemap | (Added in 2016) Treemap chart type (117) |
| xlWaterfall | (Added in 2016) Waterfall chart type (119) |
| xlXYScatter | XY Scatter chart type (-4169) |
| xlXYScatterLines | XY Scatter Lines chart type (74) |
| xlXYScatterLinesNoMarkers | XY Scatter Lines with No Markers chart type (75) |
| xlXYScatterSmooth | XY Scatter Smooth chart type (72) |
| xlXYScatterSmoothNoMarkers | XY Scatter Smooth with No Markers chart type (73) |
| xl3DArea |
| 3D Area chart type (-4098) |
| xl3DAreaStacked |
| 3D Area Stacked chart type (78) |
| xl3DAreaStacked100 |
| 3D Area Stacked 100 chart type (79) |
| xl3DBarClustered |
| 3D Bar Clustered chart type (60) |
| xl3DBarStacked |
| 3D Bar Stacked chart type (61) |
| xl3DBarStacked100 |
| 3D Bar Stacked 100 chart type (62) |
| xl3DColumn |
| 3D Column chart type (-4100) |
| xl3DColumnClustered |
| 3D Column Clustered chart type (54) |
| xl3DColumnStacked |
| 3D Column Stacked chart type (55) |
| xl3DColumnStacked100 |
| 3D Column Stacked 100 chart type (56) |
| xl3DLine |
| 3D Line chart type (-4101) |
| xl3DPie |
| 3D Pie chart type (-4102) |
| xl3DPieExploded |
| 3D Pie Exploded chart type (70) |
| xlArea |
| Area chart type (1) |
| xlAreaStacked |
| Area Stacked chart type (76) |
| xlAreaStacked100 |
| Area Stacked 100 chart type (77) |
| xlBarClustered |
| Bar Clustered chart type (57) |
| xlBarOfPie |
| Bar of Pie chart type (71) |
| xlBarStacked |
| Bar Stacked chart type (58) |
| xlBarStacked100 |
| Bar Stacked 100 chart type (59) |
| xlBoxWhisker |
| (Added in 2016) Box Whisker chart type (121) |
| xlBubble |
| Bubble chart type (15) |
| xlBubble3DEffect |
| 3D Bubble chart type (87) |
| xlColumnClustered |
| Column Clustered chart type (51) |
| xlColumnStacked |
| Column Stacked chart type (52) |
| xlColumnStacked100 |
| Column Stacked 100 chart type (53) |
| xlConeBarClustered |
| Bar Clustered Cone chart type (102) |
| xlConeBarStacked |
| Bar Stacked Cone chart type (103) |
| xlConeBarStacked100 |
| Bar Stacked 100 Cone chart type (104) |
| xlConeCol |
| Column Cone chart type (105) |
| xlConeColClustered |
| Column Clustered Cone chart type (99) |
| xlConeColStacked |
| Column Stacked Cone chart type (100) |
| xlConeColStacked100 |
| Column Stacked 100 chart type (101) |
| xlCylinderBarClustered |
| Bar Clustered Cylinder chart type (95) |
| xlCylinderBarStacked |
| Bar Stacked Cylinder chart type (96) |
| xlCylinderBarStacked100 |
| Bar Stacked 100 Cylinder chart type (97) |
| xlCylinderCol |
| Column Cylinder chart type (98) |
| xlCylinderColClustered |
| Column Clustered Cyliner chart type (92) |
| xlCylinderColStacked |
| Column Stacked Cylinder chart type (93) |
| xlCylinderColStacked100 |
| Column Stacked 100 Cylinder chart type (94) |
| xlDoughnut |
| Doughnut chart type (-4120) |
| xlDoughnutExploded |
| Doughnut Exploded chart type (80) |
| xlFunnel |
| (Added in 2019) Funnel chart type (123) |
| xlHistogram |
| (Added in 2016) Histogram chart type (118) |
| xlLine |
| Line chart type (4) |
| xlLineMarkers |
| Line with Markers chart type (65) |
| xlLineMarkersStacked |
| Line Stacked with Markers chart type (66) |
| xlLineMarkersStacked100 |
| Line Stacked 100 with Markers chart type (67) |
| xlLineStacked |
| Line Stacked chart type (63) |
| xlLineStacked100 |
| Line Stacked 100 chart type (64) |
| xlPareto |
| (Added in 2016) Pareto chart type (122) |
| xlPie |
| Pie chart type (5) |
| xlPieExploded |
| (Moved in 2013) Pie Exploded chart type (69) |
| xlPieOfPie |
| Pie of Pie chart type (68) |
| xlPyramidBarClustered |
| Bar Clustered Pyramid chart type (109) |
| xlPyramidBarStacked |
| Bar Stacked Pyramid chart type (110) |
| xlPyramidBarStacked100 |
| Bar Stacked 100 Pyramid chart type (111) |
| xlPyramidCol |
| Column Pyramid chart type 112 |
| xlPyramidColClustered |
| Column Clustered Pyramid chart type (106) |
| xlPyramidColStacked |
| Column Stacked Pyramid chart type (107) |
| xlPyramidColStacked100 |
| Column Stacked 100 Pyramid chart type (108) |
| xlRadar |
| Radar chart type (-4151) |
| xlRadarFilled |
| Radar Filled chart type (82) |
| xlRadarMarkers |
| Radar with Markers chart type (81) |
| xlRegionMap |
| (Added in 2019) Map chart type (140) |
| xlStockHLC |
| Stock High Low Close chart type (88) |
| xlStockOHLC |
| Stock Open High Low Close chart type (89) |
| xlStockVHLC |
| Stock Volume High Low Close chart type (90) |
| xlStockVOHLC |
| Stock Volume Open High Low Close chart type (91) |
| xlSunburst |
| (Added in 2016) Sunburst chart type (120) |
| xlSurface |
| Surface chart type (83) |
| xlSurfaceTopView |
| Surface Top View chart type (85) |
| xlSurfaceTopViewWireframe |
| Surface Top View Wireframe chart type (86) |
| xlSurfaceWireframe |
| Surface Wireframe chart type (84) |
| xlTreemap |
| (Added in 2016) Treemap chart type (117) |
| xlWaterfall |
| (Added in 2016) Waterfall chart type (119) |
| xlXYScatter |
| XY Scatter chart type (-4169) |
| xlXYScatterLines |
| XY Scatter Lines chart type (74) |
| xlXYScatterLinesNoMarkers |
| XY Scatter Lines with No Markers chart type (75) |
| xlXYScatterSmooth |
| XY Scatter Smooth chart type (72) |
| xlXYScatterSmoothNoMarkers |
| XY Scatter Smooth with No Markers chart type (73) |
| REMARKS |
| * -4111 is a combination chart or unrecognised chart type. |
xlDataLabelPosition |
| Specifies where the data label is positioned. |
| xlLabelPositionAbove | Data label above point (0) |
| xlLabelPositionBelow | Data label below point (1) |
| xlLabelPositionBestFit | Excel controls position of data label (5) |
| xlLabelPositionCenter | Data label centered on data point or inside bar or pie (-4108) |
| xlLabelPositionCustom | Data label centered on data point or inside bar or pie (7) |
| xlLabelPositionInsideBase | Data label positioned arbitrarily (4) |
| xlLabelPositionInsideEnd | Data label positioned at the left of bar or pie (3) |
| xlLabelPositionLeft | Data label positioned at the left of bar or pie (-4131) |
| xlLabelPositionMixed | Mixed position (6) |
| xlLabelPositionOutsideEnd | Position outside the end (2) |
| xlLabelPositionRight | Data label positioned at the right of bar or pie (-4152) |
| xlLabelPositionAbove |
| Data label above point (0) |
| xlLabelPositionBelow |
| Data label below point (1) |
| xlLabelPositionBestFit |
| Excel controls position of data label (5) |
| xlLabelPositionCenter |
| Data label centered on data point or inside bar or pie (-4108) |
| xlLabelPositionCustom |
| Data label centered on data point or inside bar or pie (7) |
| xlLabelPositionInsideBase |
| Data label positioned arbitrarily (4) |
| xlLabelPositionInsideEnd |
| Data label positioned at the left of bar or pie (3) |
| xlLabelPositionLeft |
| Data label positioned at the left of bar or pie (-4131) |
| xlLabelPositionMixed |
| Mixed position (6) |
| xlLabelPositionOutsideEnd |
| Position outside the end (2) |
| xlLabelPositionRight |
| Data label positioned at the right of bar or pie (-4152) |
| REMARKS |
| * Every chart type has a different distinct list of possible label positions. |
xlDataLabelSeparator |
| Specifies the separator used with data labels. |
| xlDataLabelSeparatorDefault | Excel selects the separator (1) |
| xlDataLabelSeparatorDefault |
| Excel selects the separator (1) |
| REMARKS |
| * Added in 2002. |
xlDataLabelsType |
| Specifies the type of data label to apply. |
| xlDataLabelsShowBubbleSizes | Show the size of the bubble in reference to the absolute value (6) |
| xlDataLabelsShowLabel | Category for the point (4) |
| xlDataLabelsShowLabelAndPercent | Percentage of the total, and category for the point Available only for pie charts and doughnut charts (5) |
| xlDataLabelsShowNone | No data labels (-4142) |
| xlDataLabelsShowPercent | Percentage of the total Available only for pie charts and doughnut charts (3) |
| xlDataLabelsShowValue | Default value for the point (assumed if this argument is not specified) (2) |
| xlDataLabelsShowBubbleSizes |
| Show the size of the bubble in reference to the absolute value (6) |
| xlDataLabelsShowLabel |
| Category for the point (4) |
| xlDataLabelsShowLabelAndPercent |
| Percentage of the total, and category for the point Available only for pie charts and doughnut charts (5) |
| xlDataLabelsShowNone |
| No data labels (-4142) |
| xlDataLabelsShowPercent |
| Percentage of the total Available only for pie charts and doughnut charts (3) |
| xlDataLabelsShowValue |
| Default value for the point (assumed if this argument is not specified) (2) |
xlDataSeriesDate |
| Specifies the type of date to apply to a data series. |
| xlDay | Day (1) |
| xlMonth | Month (3) |
| xlWeekday | Weekday (2) |
| xlYear | Year (4) |
| xlDay |
| Day (1) |
| xlMonth |
| Month (3) |
| xlWeekday |
| Weekday (2) |
| xlYear |
| Year (4) |
xlDataSeriesType |
| Specifies the data series to create. |
| xlAutoFill | Fill series according to AutoFill settings (4) |
| xlChronological | Fill with date values (3) |
| xlDataSeriesLinear | Extend values, assuming an additive progression (for example, '1, 2' is extended as '3, 4, 5') (-4132) |
| xlGrowth | Extend values, assuming a multiplicative progression (for example, '1, 2' is extended as '4, 8, 16') (2) |
| xlAutoFill |
| Fill series according to AutoFill settings (4) |
| xlChronological |
| Fill with date values (3) |
| xlDataSeriesLinear |
| Extend values, assuming an additive progression (for example, '1, 2' is extended as '3, 4, 5') (-4132) |
| xlGrowth |
| Extend values, assuming a multiplicative progression (for example, '1, 2' is extended as '4, 8, 16') (2) |
xlDisplayBlanksAs |
| Specifies how blank cells are plotted on a chart. |
| xlInterpolated | Values are interpolated into the chart (3) |
| xlNotPlotted | Blank cells are not plotted (1) |
| xlZero | Blanks are plotted as zero (2) |
| xlInterpolated |
| Values are interpolated into the chart (3) |
| xlNotPlotted |
| Blank cells are not plotted (1) |
| xlZero |
| Blanks are plotted as zero (2) |
xlDisplayUnit |
| Specifies the display unit label for an axis. |
| xlHundredMillions | Hundreds of millions (-8) |
| xlHundreds | Hundreds (-2) |
| xlHundredThousands | Hundreds of thousands (-5) |
| xlMillionMillions | Millions of millions (-10) |
| xlMillions | Millions (-6) |
| xlTenMillions | Tens of million (-7) |
| xlTenThousands | Tens of thousands (-4) |
| xlThousandMillions | Thousands of million (-9) |
| xlThousands | Thousands (-3) |
| xlHundredMillions |
| Hundreds of millions (-8) |
| xlHundreds |
| Hundreds (-2) |
| xlHundredThousands |
| Hundreds of thousands (-5) |
| xlMillionMillions |
| Millions of millions (-10) |
| xlMillions |
| Millions (-6) |
| xlTenMillions |
| Tens of million (-7) |
| xlTenThousands |
| Tens of thousands (-4) |
| xlThousandMillions |
| Thousands of million (-9) |
| xlThousands |
| Thousands (-3) |
| REMARKS |
| * Added in 2000. |
xlEndStyleCap |
| Specifies the end style for error bars. |
| xlCap | Caps applied (1) |
| xlNoCap | No caps applied (2) |
| xlCap |
| Caps applied (1) |
| xlNoCap |
| No caps applied (2) |
xlErrorBarDirection |
| Specifies which axis values are to receive error bars. |
| xlX | Bars run parallel to the Y axis for X-values (-4168) |
| xlY | Bars run parallel to the X-axis for Y-values (1) |
| xlX |
| Bars run parallel to the Y axis for X-values (-4168) |
| xlY |
| Bars run parallel to the X-axis for Y-values (1) |
xlErrorBarInclude |
| Specifies which error bar parts to include. |
| xlErrorBarIncludeBoth | Both positive and negative error range (1) |
| xlErrorBarIncludeMinusValues | Only negative error range (3) |
| xlErrorBarIncludeNone | No error bar range (-4142) |
| xlErrorBarIncludePlusValues | Only positive error range (2) |
| xlErrorBarIncludeBoth |
| Both positive and negative error range (1) |
| xlErrorBarIncludeMinusValues |
| Only negative error range (3) |
| xlErrorBarIncludeNone |
| No error bar range (-4142) |
| xlErrorBarIncludePlusValues |
| Only positive error range (2) |
xlErrorBarType |
| Specifies the range marked by error bars. |
| xlErrorBarTypeCustom | Range is set by fixed values or cell values (-4114) |
| xlErrorBarTypeFixedValue | Fixed-length error bars (1) |
| xlErrorBarTypePercent | Percentage of range to be covered by the error bars (2) |
| xlErrorBarTypeStDev | Shows range for specified number of standard deviations (-4155) |
| xlErrorBarTypeStError | Shows standard error range (4) |
| xlErrorBarTypeCustom |
| Range is set by fixed values or cell values (-4114) |
| xlErrorBarTypeFixedValue |
| Fixed-length error bars (1) |
| xlErrorBarTypePercent |
| Percentage of range to be covered by the error bars (2) |
| xlErrorBarTypeStDev |
| Shows range for specified number of standard deviations (-4155) |
| xlErrorBarTypeStError |
| Shows standard error range (4) |
xlGeoMappingLevel |
| Specifies the geography mapping level for a series within a chart group. |
| xlGeoMappingLevelAutomatic | Use highest resolution mapping level (0) |
| xlGeoMappingLevelCountryRegion | Map by country (5) |
| xlGeoMappingLevelCountryRegionList | Map by region (group of countries) (6) |
| xlGeoMappingLevelCountry | Map by country (3) |
| xlGeoMappingLevelDataOnly | Only map regions with data (1) |
| xlGeoMappingLevelPostalCode | Map by postcode (2) |
| xlGeoMappingLevelState | Map by state (4) |
| xlGeoMappingLevelWorld | Map the whole world (7) |
| xlGeoMappingLevelAutomatic |
| Use highest resolution mapping level (0) |
| xlGeoMappingLevelCountryRegion |
| Map by country (5) |
| xlGeoMappingLevelCountryRegionList |
| Map by region (group of countries) (6) |
| xlGeoMappingLevelCountry |
| Map by country (3) |
| xlGeoMappingLevelDataOnly |
| Only map regions with data (1) |
| xlGeoMappingLevelPostalCode |
| Map by postcode (2) |
| xlGeoMappingLevelState |
| Map by state (4) |
| xlGeoMappingLevelWorld |
| Map the whole world (7) |
| REMARKS |
| * Added in 2019. |
xlGeoProjectionType |
| Specifies the geography projection type for a series within the chart group. |
| xlGeoProjectionTypeAlbers | Use the Albers map projection (3) |
| xlGeoProjectionTypeAutomatic | Heuristically choose best map projection (0) |
| xlGeoProjectionTypeMercator | Use the Mercator map projection (1) |
| xlGeoProjectionTypeMiller | Use the Miller map projection (2) |
| xlGeoProjectionTypeRobinson | Use the Robinson map projection (4) |
| xlGeoProjectionTypeAlbers |
| Use the Albers map projection (3) |
| xlGeoProjectionTypeAutomatic |
| Heuristically choose best map projection (0) |
| xlGeoProjectionTypeMercator |
| Use the Mercator map projection (1) |
| xlGeoProjectionTypeMiller |
| Use the Miller map projection (2) |
| xlGeoProjectionTypeRobinson |
| Use the Robinson map projection (4) |
| REMARKS |
| * Added in 2019. |
xlLegendPosition |
| Specifies the position of the legend on a chart. |
| xlLegendPositionBottom | Bottom (-4107) |
| xlLegendPositionCorner | Corner (2) |
| xlLegendPositionLeft | Left (-4131) |
| xlLegendPositionRight | Right (-4152) |
| xlLegendPositionTop | Top (-4160) |
| xlLegendPositionCustom | (Added in 2007) Custom (-4161) |
| xlLegendPositionBottom |
| Bottom (-4107) |
| xlLegendPositionCorner |
| Corner (2) |
| xlLegendPositionLeft |
| Left (-4131) |
| xlLegendPositionRight |
| Right (-4152) |
| xlLegendPositionTop |
| Top (-4160) |
| xlLegendPositionCustom |
| (Added in 2007) Custom (-4161) |
xlMarkerStyle |
| Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart. |
| xlMarkerStyleAutomatic | Automatic (-4105) |
| xlMarkerStyleCircle | Circle (8) |
| xlMarkerStyleDash | Dash (-4115) |
| xlMarkerStyleDiamond | Diamond (2) |
| xlMarkerStyleDot | Dot (-4118) |
| xlMarkerStyleNone | None (-4142) |
| xlMarkerStylePicture | Picture (-4147) |
| xlMarkerStylePlus | Plus (9) |
| xlMarkerStyleSquare | Square (1) |
| xlMarkerStyleStar | Star (5) |
| xlMarkerStyleTriangle | Triangle (3) |
| xlMarkerStyleX | X (-4168) |
| xlMarkerStyleAutomatic |
| Automatic (-4105) |
| xlMarkerStyleCircle |
| Circle (8) |
| xlMarkerStyleDash |
| Dash (-4115) |
| xlMarkerStyleDiamond |
| Diamond (2) |
| xlMarkerStyleDot |
| Dot (-4118) |
| xlMarkerStyleNone |
| None (-4142) |
| xlMarkerStylePicture |
| Picture (-4147) |
| xlMarkerStylePlus |
| Plus (9) |
| xlMarkerStyleSquare |
| Square (1) |
| xlMarkerStyleStar |
| Star (5) |
| xlMarkerStyleTriangle |
| Triangle (3) |
| xlMarkerStyleX |
| X (-4168) |
xlObjectSize |
| Specifies the way a chart is scaled to fit on a page. |
| xlFitToPage | Fit to Page (2) |
| xlFullPage | Full Page (3) |
| xlScreenSize | Screen Size (1) |
| xlFitToPage |
| Fit to Page (2) |
| xlFullPage |
| Full Page (3) |
| xlScreenSize |
| Screen Size (1) |
xlPieSliceIndex |
| Specifies which position on the slice to return the coordinate of. |
| xlCenterPoint | The center point of a pie slice (5) |
| xlInnerCenterPoint | The innermost center point of a doughnut slice (8) |
| xlInnerClockwisePoint | The innermost point of the most clockwise radius of a doughnut slice (7) |
| xlInnerCounterClockwisePoint | The innermost point of the most counterclockwise radius of a doughnut slice (9) |
| xlMidClockwiseRadiusPoint | The midpoint of the most clockwise radius of a slice (4) |
| xlMidCounterClockwiseRadiusPoint | The midpoint of the most counterclockwise radius of a slice (6) |
| xlOuterCenterPoint | The outer center point of the circumference of a slice (2) |
| xlOuterClockwisePoint | The outermost clockwise point of the circumference of a slice (3) |
| xlOuterCounterClockwisePoint | The outermost counterclockwise point of the circumference of a slice (1) |
| xlCenterPoint |
| The center point of a pie slice (5) |
| xlInnerCenterPoint |
| The innermost center point of a doughnut slice (8) |
| xlInnerClockwisePoint |
| The innermost point of the most clockwise radius of a doughnut slice (7) |
| xlInnerCounterClockwisePoint |
| The innermost point of the most counterclockwise radius of a doughnut slice (9) |
| xlMidClockwiseRadiusPoint |
| The midpoint of the most clockwise radius of a slice (4) |
| xlMidCounterClockwiseRadiusPoint |
| The midpoint of the most counterclockwise radius of a slice (6) |
| xlOuterCenterPoint |
| The outer center point of the circumference of a slice (2) |
| xlOuterClockwisePoint |
| The outermost clockwise point of the circumference of a slice (3) |
| xlOuterCounterClockwisePoint |
| The outermost counterclockwise point of the circumference of a slice (1) |
| REMARKS |
| * Added in 2010. |
xlPieSliceLocation |
| Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area. |
| xlHorizontalCoordinate | The horizontal coordinate (x) (1) |
| xlVerticalCoordinate | The vertical coordinate (y) (2) |
| xlHorizontalCoordinate |
| The horizontal coordinate (x) (1) |
| xlVerticalCoordinate |
| The vertical coordinate (y) (2) |
| REMARKS |
| * Added in 2010. |
xlRegionLabelOptions |
| Specifies the region labelling behavior for a series within the chart group. |
| xlRegionLabelOptionsBestFitOnly | Only show labels that can be fitted within the bounds of their regions (1) |
| xlRegionLabelOptionsNone | Don't show region labels (0) |
| xlRegionLabelOptionsShowAll | Show all region labels (2) |
| xlRegionLabelOptionsBestFitOnly |
| Only show labels that can be fitted within the bounds of their regions (1) |
| xlRegionLabelOptionsNone |
| Don't show region labels (0) |
| xlRegionLabelOptionsShowAll |
| Show all region labels (2) |
| REMARKS |
| * Added in 2019. |
xlRowCol |
| Specifies whether the values corresponding to a particular data series are in rows or columns. |
| xlColumns | 2 |
| xlRows | 1 |
| xlColumns |
| 2 |
| xlRows |
| 1 |
xlScaleType |
| Specifies the scale type of the value axis. |
| xlScaleLinear | -4132 |
| xlScaleLogarithmic | -4133 |
| xlScaleLinear |
| -4132 |
| xlScaleLogarithmic |
| -4133 |
xlTickLabelOrientation |
| Specifies the text orientation for tick-mark labels. |
| xlTickLabelOrientationAutomatic | -4105 |
| xlTickLabelOrientationDownward | -4170 |
| xlTickLabelOrientationHorizontal | -4128 |
| xlTickLabelOrientationUpward | -4171 |
| xlTickLabelOrientationVertical | -4166 |
| xlTickLabelOrientationAutomatic |
| -4105 |
| xlTickLabelOrientationDownward |
| -4170 |
| xlTickLabelOrientationHorizontal |
| -4128 |
| xlTickLabelOrientationUpward |
| -4171 |
| xlTickLabelOrientationVertical |
| -4166 |
xlTickLabelPosition |
| Specifies the position of tick-mark labels on the specified axis. |
| xlTickLabelPositionHigh | -4127 |
| xlTickLabelPositionLow | -4134 |
| xlTickLabelPositionNextToAxis | 4 |
| xlTickLabelPositionNone | -4142 |
| xlTickLabelPositionHigh |
| -4127 |
| xlTickLabelPositionLow |
| -4134 |
| xlTickLabelPositionNextToAxis |
| 4 |
| xlTickLabelPositionNone |
| -4142 |
xlTickMark |
| Specifies the position of major and minor tick marks for an axis. |
| xlTickMarkCross | 4 |
| xlTickMarkInside | 2 |
| xlTickMarkNone | -4142 |
| xlTickMarkOutside | 3 |
| xlTickMarkCross |
| 4 |
| xlTickMarkInside |
| 2 |
| xlTickMarkNone |
| -4142 |
| xlTickMarkOutside |
| 3 |
xlTimeUnit |
| Specifies unit of time for chart axis and data series. |
| xlDays | 0 |
| xlMonths | 1 |
| xlYears | 2 |
| xlDays |
| 0 |
| xlMonths |
| 1 |
| xlYears |
| 2 |
xlTrendlineType |
| Specifies how the trendline that smoothes out fluctuations in the data is calculated. |
| xlExponential | 5 |
| xlLinear | -4132 |
| xlLogarithmic | -4133 |
| xlMovingAvg | 6 |
| xlPolynomial | 3 |
| xlPower | 4 |
| xlExponential |
| 5 |
| xlLinear |
| -4132 |
| xlLogarithmic |
| -4133 |
| xlMovingAvg |
| 6 |
| xlPolynomial |
| 3 |
| xlPower |
| 4 |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top