Chart.ApplyLayout method (Excel)

Applies the layouts shown in the ribbon.


expression.ApplyLayout (Layout, ChartType)

expression A variable that represents a Chart object.


Name Required/Optional Data type Description
Layout Required Long Specifies the type of layout. The type of layout is denoted by a number from 1 to 10.
ChartType Optional XlChartType The type of chart.


When you use a layout on the current chart type, a number from 1 to 10 is applied to the chart type. You can also apply the layout of one chart type on another chart type. For example, you can apply the layouts that are available from a line chart to a column chart. The layout only adds chart elements that are available for that particular chart type.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.