msoChartElementType

Specifies whether and how to display chart elements.

msoElementChartFloorNoneDo not display chart floor (1200)
msoElementChartFloorShowDisplay chart floor (1201)
msoElementChartTitleAboveChartDisplay title above chart (2)
msoElementChartTitleCenteredOverlayDisplay title as centered overlay (1)
msoElementChartTitleNoneDo not display chart floor (0)
msoElementChartWallNoneDo not display chart wall (1100)
msoElementChartWallShowDisplay chart wall (1101)
msoElementDataLabelBestFitUse best fit for data label (210)
msoElementDataLabelBottomDisplay data label at bottom (209)
msoElementDataLabelCallout(Not in 2016) Display data label as a callout ()
msoElementDataLabelCenterDisplay data label in center (202)
msoElementDataLabelInsideBaseDisplay data label inside at the base (204)
msoElementDataLabelInsideEndDisplay data label inside at the end (203)
msoElementDataLabelLeftDisplay data label to the left (206)
msoElementDataLabelNoneDo not display data label (200)
msoElementDataLabelOutSideEndDisplay data label outside at the end (205)
msoElementDataLabelRightDisplay data label to the right (207)
msoElementDataLabelShowDisplay data label (201)
msoElementDataLabelTopDisplay data label at the top (208)
msoElementDataTableNoneDo not display data table (500)
msoElementDataTableShowDisplay data table (501)
msoElementDataTableWithLegendKeysDisplay data table with legend keys (502)
msoElementErrorBarNoneDo not display error bar (700)
msoElementErrorBarPercentageDisplay percentage error bar (702)
msoElementErrorBarStandardDeviationDisplay standard deviation error bar (703)
msoElementErrorBarStandardErrorDisplay standard error bar (701)
msoElementLegendBottomDisplay legend at the bottom (104)
msoElementLegendLeftDisplay legend on the left (103)
msoElementLegendLeftOverlayOverlay legend at the left (106)
msoElementLegendNoneDo not display legend (100)
msoElementLegendRightDisplay legend at the right (101)
msoElementLegendRightOverlayOverlay legend at the right (105)
msoElementLegendTopDisplay legend at the top (102)
msoElementLineDropHiLoLineDisplay drop high/low line (804)
msoElementLineDropLineDisplay drop line (801)
msoElementLineHiLoLineDisplay high/low line (802)
msoElementLineNoneDo not display line (800)
msoElementLineSeriesLineDisplay series line (803)
msoElementPlotAreaNoneDo not display plot area (1000)
msoElementPlotAreaShowDisplay plot area (1001)
msoElementPrimaryCategoryAxisBillionsUse billions for primary category axis units (374)
msoElementPrimaryCategoryAxisLogScaleUse log scale for primary category axis (375)
msoElementPrimaryCategoryAxisMillionsUse millions for primary category axis units (373)
msoElementPrimaryCategoryAxisNoneDo not display primary category axis (348)
msoElementPrimaryCategoryAxisReverseReverse primary category axis (351)
msoElementPrimaryCategoryAxisShowShow primary category axis (349)
msoElementPrimaryCategoryAxisThousandsUse thousands for primary category axis units (372)
msoElementPrimaryCategoryAxisTitleAdjacentToAxisDisplay primary category axis title adjacent to the axis (301)
msoElementPrimaryCategoryAxisTitleBelowAxisDisplay primary category axis title below the axis (302)
msoElementPrimaryCategoryAxisTitleHorizontalDisplay primary category axis title horizontally (305)
msoElementPrimaryCategoryAxisTitleNoneDo not display primary category axis title (300)
msoElementPrimaryCategoryAxisTitleRotatedRotate primary category axis title (303)
msoElementPrimaryCategoryAxisTitleVerticalDisplay primary category axis title vertically (304)
msoElementPrimaryCategoryAxisWithoutLabelsDisplay primary category axis without labels (350)
msoElementPrimaryCategoryGridLinesMajorDisplay major gridlines along primary category axis (334)
msoElementPrimaryCategoryGridLinesMinorDisplay minor gridlines along primary category axis (333)
msoElementPrimaryCategoryGridLinesMinorMajorDisplay both major and minor gridlines along primary category axis (335)
msoElementPrimaryCategoryGridLinesNoneDo not display grid lines along primary category axis (332)
msoElementPrimaryValueAxisBillionsUse billions for primary value axis units (356)
msoElementPrimaryValueAxisLogScaleUse log scale for primary value axis (357)
msoElementPrimaryValueAxisMillionsUse millions for primary value axis units (355)
msoElementPrimaryValueAxisNoneDo not display primary value axis (352)
msoElementPrimaryValueAxisShowShow primary value axis (353)
msoElementPrimaryValueAxisThousandsUse thousands for primary value axis units (354)
msoElementPrimaryValueAxisTitleAdjacentToAxisPlace primary value axis title adjacent to the axis (306)
msoElementPrimaryValueAxisTitleBelowAxisPlace primary value axis title below the axis (308)
msoElementPrimaryValueAxisTitleHorizontalDisplay primary value axis title horizontally (311)
msoElementPrimaryValueAxisTitleNoneDo not display primary value axis (306)
msoElementPrimaryValueAxisTitleRotatedRotate primary value axis title (309)
msoElementPrimaryValueAxisTitleVerticalDisplay primary value axis title vertically (310)
msoElementPrimaryValueGridLinesMajorDisplay major gridlines along primary value axis (330)
msoElementPrimaryValueGridLinesMinorDisplay minor gridlines along primary value axis (329)
msoElementPrimaryValueGridLinesMinorMajorDisplay both major and minor gridlines along primary value axis (331)
msoElementPrimaryValueGridLinesNoneDo not display grid lines along primary value axis (328)
msoElementSecondaryCategoryAxisBillionsUse billions for secondary category axis units (378)
msoElementSecondaryCategoryAxisLogScaleUse log scale for secondary category axis (379)
msoElementSecondaryCategoryAxisMillionsUse millions for secondary category axis units (377)
msoElementSecondaryCategoryAxisNoneDo not display secondary category axis (358)
msoElementSecondaryCategoryAxisReverseReverse secondary category axis (361)
msoElementSecondaryCategoryAxisShowDisplay secondary category axis (359)
msoElementSecondaryCategoryAxisThousandsUse thousands for secondary category axis units (376)
msoElementSecondaryCategoryAxisTitleAdjacentToAxisDisplay secondary category axis title adjacent to axis (313)
msoElementSecondaryCategoryAxisTitleBelowAxisDisplay secondary category axis title below axis (314)
msoElementSecondaryCategoryAxisTitleHorizontalDisplay secondary category axis title horizontally (317)
msoElementSecondaryCategoryAxisTitleNoneDo not display secondary category axis (312)
msoElementSecondaryCategoryAxisTitleRotatedRotate secondary category axis title (315)
msoElementSecondaryCategoryAxisTitleVerticalDisplay secondary category axis title vertically (316)
msoElementSecondaryCategoryAxisWithoutLabelsDisplay secondary category axis without labels (360)
msoElementSecondaryCategoryGridLinesMajorDisplay major gridlines along secondary category axis (342)
msoElementSecondaryCategoryGridLinesMinorDisplay minor gridlines along secondary category axis (341)
msoElementSecondaryCategoryGridLinesMinorMajorDisplay both major and minor gridlines along secondary category axis (343)
msoElementSecondaryCategoryGridLinesNoneDo not display grid lines along secondary category axis (340)
msoElementSecondaryValueAxisBillionsUse billions for secondary value axis units (366)
msoElementSecondaryValueAxisLogScaleUse log scale for secondary value axis (367)
msoElementSecondaryValueAxisMillionsUse millions for secondary category axis units (365)
msoElementSecondaryValueAxisNoneDo not display secondary category axis (362)
msoElementSecondaryValueAxisShowDisplay secondary category axis (363)
msoElementSecondaryValueAxisThousandsUse thousands for secondary category axis units (364)
msoElementSecondaryValueAxisTitleAdjacentToAxisDisplay secondary category axis title adjacent to axis (319)
msoElementSecondaryValueAxisTitleBelowAxisDisplay secondary category axis title below axis (320)
msoElementSecondaryValueAxisTitleHorizontalDisplay secondary category axis title horizontally (323)
msoElementSecondaryValueAxisTitleNoneDo not display secondary category axis title (318)
msoElementSecondaryValueAxisTitleRotatedRotate secondary category axis title (321)
msoElementSecondaryValueAxisTitleVerticalDisplay secondary category axis title vertically (322)
msoElementSecondaryValueGridLinesMajorDisplay major gridlines along secondary value axis (338)
msoElementSecondaryValueGridLinesMinorDisplay minor gridlines along secondary value axis (337)
msoElementSecondaryValueGridLinesMinorMajorDisplay both major and minor gridlines along secondary value axis (339)
msoElementSecondaryValueGridLinesNoneDo not display gridlines along secondary value axis (336)
msoElementSeriesAxisGridLinesMajorDisplay major gridlines along series axis (346)
msoElementSeriesAxisGridLinesMinorDisplay minor gridlines along series axis (345)
msoElementSeriesAxisGridLinesMinorMajorDisplay both major and minor gridlines along series axis (347)
msoElementSeriesAxisGridLinesNoneDo not display gridlines along series axis (344)
msoElementSeriesAxisNoneDo not display series axis (368)
msoElementSeriesAxisReverseReverse series axis (371)
msoElementSeriesAxisShowDisplay series axis (369)
msoElementSeriesAxisTitleHorizontalDisplay series axis title horizontally (327)
msoElementSeriesAxisTitleNoneDo not display series axis title (324)
msoElementSeriesAxisTitleRotatedRotate series axis title (325)
msoElementSeriesAxisTitleVerticalDisplay series axis title vertically (326)
msoElementSeriesAxisWithoutLabelingDisplay series axis title without labeling (370)
msoElementTrendlineAddExponentialAdd an exponential trendline (602)
msoElementTrendlineAddLinearAdd a linear trendline (601)
msoElementTrendlineAddLinearForecastAdd a linear forecast (603)
msoElementTrendlineAddTwoPeriodMovingAverageAdd a two-period moving average (604)
msoElementTrendlineNoneDo not display trendline (600)
msoElementUpDownBarsNoneDo not display up/down bars (900)
msoElementUpDownBarsShowDisplay up/down bars (901)

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

REMARKS
* Added in 2007.
* Returned from Chart.SetElement

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top