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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for