Chart.ApplyLayout method (Excel)
Applies the layouts shown in the ribbon.
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.
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.