Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Chart.ApplyLayout Method

Office 2007
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

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.

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.




Community Additions

Show:
© 2015 Microsoft