Chart.ApplyLayout (Excel)
Applies the layouts shown in the ribbon.
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.
ApplyLayout (Layout, ChartType)
Dim lngLayout As Long: lngLayout =
ActiveChart.ApplyLayout Layout:=lngLayout
Arguments
The following argument is required
Layout (Long) - Specifies the type of layout. The type of layout is denoted by a number from 1 to 10.
Optional arguments
The following argument is optional
ChartType (XlChartType) - The type of chart.
Here you can find possible values for