This documentation is archived and is not being maintained.

Chart.ApplyLayout Method

Office 2007
Applies the layouts shown in the ribbon.

Version Information
 Version Added:  Excel 2007


expression.ApplyLayout(Layout, ChartType)

expression   A variable that represents a Chart object.


NameRequired/OptionalData TypeDescription
LayoutRequiredLongSpecifies the type of layout. The type of layout is denoted by a number from 1 to 10.
ChartTypeOptionalXlChartTypeThe 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.