Skip to content

Latest commit

 

History

History
68 lines (40 loc) · 1.59 KB

Excel.Chart.SetElement.md

File metadata and controls

68 lines (40 loc) · 1.59 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Chart.SetElement method (Excel)
vbaxl10.chm149175
vbaxl10.chm149175
Excel.Chart.SetElement
0efff437-179b-fe16-118b-6f3cde49c5cf
04/16/2019
medium

Chart.SetElement method (Excel)

Sets chart elements on a chart. Read/write MsoChartElementType.

Syntax

expression.SetElement (Element)

expression A variable that represents a Chart object.

Parameters

Name Required/Optional Data type Description
Element Required MsoChartElementType Specifies the chart element type.

Return value

Nothing

Remarks

For charts, the following commands in the Layout tab correspond to the SetElement method:

  • Everything in the Labels group.

  • Everything in the Axes group.

  • Everything in the Analysis group.

  • PlotArea, Chart Wall, and Chart Floor buttons.

MsoChartElementType is an enumeration of constants that refer to all of the above commands.

Example

This example sets chart elements by using the various constant values to an active chart.

ActiveChart.Axes(xlValue).MajorGridlines.Select 
 ActiveChart.SetElement (msoElementChartTitleCenteredOverlay) 
 ActiveChart.SetElement (msoElementPrimaryCategoryGridLinesMinor) 
 ActiveChart.Walls.Select 
 Application.CommandBars("Clip Art").Visible = False 
 ActiveChart.SetElement (msoElementChartFloorShow)

[!includeSupport and feedback]