MsoChartElementType Enumeration (Office)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Dispaly 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

306

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

Dispaly secondary category axis title adjacent to axis.

msoElementSecondaryCategoryAxisTitleBelowAxis

314

Dispaly 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.

Show: