ChartWizard Method

Microsoft Excel Visual Basic

expression.ChartWizard(Source, Gallery, Format, PlotBy, CategoryLabels, SeriesLabels, HasLegend, Title, CategoryTitle, ValueTitle, ExtraTitle)

expression    Required. An expression that returns one of the objects in the Applies To list.

Source   Optional Variant. The range that contains the source data for the new chart. If this argument is omitted, Microsoft Excel edits the active chart sheet or the selected chart on the active worksheet.

Gallery   Optional XlChartType. The chart type.

XlChartType can be one of these XlChartType constants.
xlArea
xlBar
xlColumn

xlLine

xlPie

xlRadar

xlXYScatter

xlCombination

xl3DArea

xl3DBar

xl3DColumn

xl3DLine

xl3DPie

xl3DSurface

xlDoughnut

xlDefaultAutoFormat

Format   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, Microsoft Excel chooses a default value based on the gallery type and data source.

PlotBy   Optional Variant. Specifies whether the data for each series is in rows or columns. Can be one of the following XlRowCol constants: xlRows or xlColumns.

CategoryLabels   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.

SeriesLabels   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.

HasLegend   Optional Variant. True to include a legend.

Title   Optional Variant. The chart title text.

CategoryTitle   Optional Variant. The category axis title text.

ValueTitle   Optional Variant. . The value axis title text

ExtraTitle   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 isn't an embedded chart on the active worksheet or the active sheet isn't an existing 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.

Charts("Chart1").ChartWizard _
    Gallery:=xlLine, _
    HasLegend:=True, CategoryTitle:="Year", ValueTitle:="Sales"