Chart.ApplyLayout Method
| Excel Developer Reference |
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 | XlChartType | 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.
See Also