MsoChartElementType enumeration (Office)

Specifies whether and how to display chart elements.


Name Value Description
msoElementChartFloorNone 1200 Do not display chart floor.
msoElementChartFloorShow 1201 Display chart floor.
msoElementChartTitleAboveChart 2 Display title above chart.
msoElementChartTitleCenteredOverlay 1 Display title as centered overlay.
msoElementChartTitleNone 0 Do not display chart title.
msoElementChartWallNone 1100 Do not display chart wall.
msoElementChartWallShow 1101 Display chart wall.
msoElementDataLabelBestFit 210 Use best fit for data label.
msoElementDataLabelBottom 209 Display data label at bottom.
msoElementDataLabelCallout 211 Display data label as a callout.
msoElementDataLabelCenter 202 Display data label in center.
msoElementDataLabelInsideBase 204 Display data label inside at the base.
msoElementDataLabelInsideEnd 203 Display data label inside at the end.
msoElementDataLabelLeft 206 Display data label to the left.
msoElementDataLabelNone 200 Do not display data label.
msoElementDataLabelOutSideEnd 205 Display data label outside at the end.
msoElementDataLabelRight 207 Display data label to the right.
msoElementDataLabelShow 201 Display data label.
msoElementDataLabelTop 208 Display data label at the top.
msoElementDataTableNone 500 Do not display data table.
msoElementDataTableShow 501 Display data table.
msoElementDataTableWithLegendKeys 502 Display data table with legend keys.
msoElementErrorBarNone 700 Do not display error bar.
msoElementErrorBarPercentage 702 Display percentage error bar.
msoElementErrorBarStandardDeviation 703 Display standard deviation error bar.
msoElementErrorBarStandardError 701 Display standard error bar.
msoElementLegendBottom 104 Display legend at the bottom.
msoElementLegendLeft 103 Display legend at the left.
msoElementLegendLeftOverlay 106 Overlay legend at the left.
msoElementLegendNone 100 Do not display legend.
msoElementLegendRight 101 Display legend at the right.
msoElementLegendRightOverlay 105 Overlay legend at the right.
msoElementLegendTop 102 Display legend at the top.
msoElementLineDropHiLoLine 804 Display drop high/low line.
msoElementLineDropLine 801 Display drop line.
msoElementLineHiLoLine 802 Display high/low line.
msoElementLineNone 800 Do not display line.
msoElementLineSeriesLine 803 Display series line.
msoElementPlotAreaNone 1000 Do not display plot area.
msoElementPlotAreaShow 1001 Display plot area.
msoElementPrimaryCategoryAxisBillions 374 Use billions for primary category axis units.
msoElementPrimaryCategoryAxisLogScale 375 Use log scale for primary category axis.
msoElementPrimaryCategoryAxisMillions 373 Use millions for primary category axis units.
msoElementPrimaryCategoryAxisNone 348 Do not display primary category axis.
msoElementPrimaryCategoryAxisReverse 351 Reverse primary category axis.
msoElementPrimaryCategoryAxisShow 349 Show primary category axis.
msoElementPrimaryCategoryAxisThousands 372 Use thousands for primary category axis units.
msoElementPrimaryCategoryAxisTitleAdjacentToAxis 301 Display primary category axis title adjacent to the axis.
msoElementPrimaryCategoryAxisTitleBelowAxis 302 Display primary category axis title below the axis.
msoElementPrimaryCategoryAxisTitleHorizontal 305 Display primary category axis title horizontally.
msoElementPrimaryCategoryAxisTitleNone 300 Do not display primary category axis title.
msoElementPrimaryCategoryAxisTitleRotated 303 Rotate primary category axis title.
msoElementPrimaryCategoryAxisTitleVertical 304 Display primary category axis title vertically.
msoElementPrimaryCategoryAxisWithoutLabels 350 Display primary category axis without labels.
msoElementPrimaryCategoryGridLinesMajor 334 Display major gridlines along primary category axis.
msoElementPrimaryCategoryGridLinesMinor 333 Display minor gridlines along primary category axis.
msoElementPrimaryCategoryGridLinesMinorMajor 335 Display both major and minor gridlines along primary category axis.
msoElementPrimaryCategoryGridLinesNone 332 Do not display grid lines along primary category axis.
msoElementPrimaryValueAxisBillions 356 Use billions for primary value axis units.
msoElementPrimaryValueAxisLogScale 357 Use log scale for primary value axis.
msoElementPrimaryValueAxisMillions 355 Use millions for primary value axis units.
msoElementPrimaryValueAxisNone 352 Do not display primary value axis.
msoElementPrimaryValueAxisShow 353 Show primary value axis
msoElementPrimaryValueAxisThousands 354 Use thousands for primary value axis units.
msoElementPrimaryValueAxisTitleAdjacentToAxis 307 Place primary value axis title adjacent to the axis.
msoElementPrimaryValueAxisTitleBelowAxis 308 Place primary value axis title below the axis.
msoElementPrimaryValueAxisTitleHorizontal 311 Display primary value axis title horizontally.
msoElementPrimaryValueAxisTitleNone 306 Do not display primary value axis title.
msoElementPrimaryValueAxisTitleRotated 309 Rotate primary value axis title.
msoElementPrimaryValueAxisTitleVertical 310 Display primary value axis title vertically.
msoElementPrimaryValueGridLinesMajor 330 Display major gridlines along primary value axis.
msoElementPrimaryValueGridLinesMinor 329 Display minor gridlines along primary value axis.
msoElementPrimaryValueGridLinesMinorMajor 331 Display both major and minor gridlines along primary value axis.
msoElementPrimaryValueGridLinesNone 328 Do not display grid lines along primary value axis.
msoElementSecondaryCategoryAxisBillions 378 Use billions for secondary category axis units.
msoElementSecondaryCategoryAxisLogScale 379 Use log scale for secondary category axis.
msoElementSecondaryCategoryAxisMillions 377 Use millions for secondary category axis units.
msoElementSecondaryCategoryAxisNone 358 Do not display secondary category axis.
msoElementSecondaryCategoryAxisReverse 361 Reverse secondary category axis.
msoElementSecondaryCategoryAxisShow 359 Display secondary category axis.
msoElementSecondaryCategoryAxisThousands 376 Use thousands for secondary category axis units.
msoElementSecondaryCategoryAxisTitleAdjacentToAxis 313 Display secondary category axis title adjacent to axis.
msoElementSecondaryCategoryAxisTitleBelowAxis 314 Display secondary category axis title below axis.
msoElementSecondaryCategoryAxisTitleHorizontal 317 Display secondary category axis title horizontally.
msoElementSecondaryCategoryAxisTitleNone 312 Do not display secondary category axis title.
msoElementSecondaryCategoryAxisTitleRotated 315 Rotate secondary category axis title.
msoElementSecondaryCategoryAxisTitleVertical 316 Display secondary category axis title vertically.
msoElementSecondaryCategoryAxisWithoutLabels 360 Display secondary category axis without labels.
msoElementSecondaryCategoryGridLinesMajor 342 Display major gridlines along secondary category axis.
msoElementSecondaryCategoryGridLinesMinor 341 Display minor gridlines along secondary category axis.
msoElementSecondaryCategoryGridLinesMinorMajor 343 Display both major and minor gridlines along secondary category axis.
msoElementSecondaryCategoryGridLinesNone 340 Do not display grid lines along secondary category axis.
msoElementSecondaryValueAxisBillions 366 Use billions for secondary value axis units.
msoElementSecondaryValueAxisLogScale 367 Use log scale for secondary value axis.
msoElementSecondaryValueAxisMillions 365 Use millions for secondary value axis units.
msoElementSecondaryValueAxisNone 362 Do not display secondary value axis.
msoElementSecondaryValueAxisShow 363 Display secondary value axis.
msoElementSecondaryValueAxisThousands 364 Use thousands for secondary value axis units.
msoElementSecondaryValueAxisTitleAdjacentToAxis 319 Display secondary value axis title adjacent to axis.
msoElementSecondaryValueAxisTitleBelowAxis 320 Display secondary value axis title below axis.
msoElementSecondaryValueAxisTitleHorizontal 323 Display secondary value axis title horizontally.
msoElementSecondaryValueAxisTitleNone 318 Do not display secondary value axis title.
msoElementSecondaryValueAxisTitleRotated 321 Rotate secondary value axis title.
msoElementSecondaryValueAxisTitleVertical 322 Display secondary value axis title vertically.
msoElementSecondaryValueGridLinesMajor 338 Display major gridlines along secondary value axis.
msoElementSecondaryValueGridLinesMinor 337 Display minor gridlines along secondary value axis.
msoElementSecondaryValueGridLinesMinorMajor 339 Display both major and minor gridlines along secondary value axis.
msoElementSecondaryValueGridLinesNone 336 Do not display gridlines along secondary value axis.
msoElementSeriesAxisGridLinesMajor 346 Display major gridlines along series axis.
msoElementSeriesAxisGridLinesMinor 345 Display minor gridlines along series axis.
msoElementSeriesAxisGridLinesMinorMajor 347 Display both major and minor gridlines along series axis.
msoElementSeriesAxisGridLinesNone 344 Do not display gridlines along series axis.
msoElementSeriesAxisNone 368 Do not display series axis.
msoElementSeriesAxisReverse 371 Reverse series axis.
msoElementSeriesAxisShow 369 Display series axis.
msoElementSeriesAxisTitleHorizontal 327 Display series axis title horizontally.
msoElementSeriesAxisTitleNone 324 Do not display series axis title.
msoElementSeriesAxisTitleRotated 325 Rotate series axis title.
msoElementSeriesAxisTitleVertical 326 Display series axis title vertically.
msoElementSeriesAxisWithoutLabeling 370 Display series axis title without labeling.
msoElementTrendlineAddExponential 602 Add an exponential trendline.
msoElementTrendlineAddLinear 601 Add a linear trendline.
msoElementTrendlineAddLinearForecast 603 Add a linear forecast.
msoElementTrendlineAddTwoPeriodMovingAverage 604 Add a two-period moving average.
msoElementTrendlineNone 600 Do not display trendline.
msoElementUpDownBarsNone 900 Do not display up/down bars.
msoElementUpDownBarsShow 901 Display up/down 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.