Chart.ApplyLayout Method (Excel)
Applies the layouts shown in the ribbon.
Version Information
Version Added: Excel 2007
Syntax
expression .ApplyLayout(Layout, ChartType)
expression A variable that represents a Chart object.
Parameters
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 |
The type of chart. |
Remarks
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.