Export (0) Print
Expand All

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

ADD
Show:
© 2015 Microsoft