Modifies the properties of the given chart. You can use this method to quickly format a chart without setting all the individual properties. This method is non-interactive, and it changes only the specified properties.

Syntax

expression.ChartWizard(varSource, varGallery, varFormat, varPlotBy, varCategoryLabels, varSeriesLabels, varHasLegend, varTitle, varCategoryTitle, varValueTitle, varExtraTitle)

expression An expression that returns a Chart object.

Parameters

Name Required/Optional Data Type Description
varSource Optional Variant The range that contains the source data for the new chart. If this argument is omitted, Microsoft Office PowerPoint edits the active slide or the selected chart on the active presentation.
varGallery Optional Variant One of the constants of PpChartType specifying the chart type.
varFormat Optional Variant The option number for the built-in autoformats. Can be a number from 1 through 10, depending on the gallery type. If this argument is omitted, PowerPoint chooses a default value based on the gallery type and data source.
varPlotBy Optional Variant Specifies whether the data for each series is in rows or columns. Can be one of the following PpRowCol constants: ppRows or ppColumns.
varCategoryLabels Optional Variant An integer specifying the number of rows or columns within the source range that contain category labels. Legal values are from 0 (zero) through one less than the maximum number of the corresponding categories or series.
varSeriesLabels Optional Variant An integer specifying the number of rows or columns within the source range that contain series labels. Legal values are from 0 (zero) through one less than the maximum number of the corresponding categories or series.
varHasLegend Optional Variant True to include a legend.
varTitle Optional Variant The chart title text.
varCategoryTitle Optional Variant The category axis title text.
varValueTitle Optional Variant The value axis title text
varExtraTitle Optional Variant The series axis title for 3-D charts or the second value axis title for 2-D charts.

Remarks

If Source is omitted, and either the selection is not an embedded chart on the active presentation or the active slide does not contain a chart, this method fails and an error occurs.

Example

This example reformats Chart1 as a line chart, adds a legend, and adds category and value axis titles.

Visual Basic for Applications 
Charts("Chart1").ChartWizard _ Gallery:=ppLine, _ HasLegend:=True, CategoryTitle:="Year", ValueTitle:="Sales"

See also: