msoChartElementType |
| Specifies whether and how to display chart elements. |
| 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) |
| 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 |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top