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)

REMARKS
* This enumeration was added in 2007.
* Returned from Chart.SetElement

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