Chart.ChartWizard Method (PowerPoint)
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 noninteractive, and it changes only the specified properties.
Version Information
Version Added: PowerPoint 2007
Syntax
expression .ChartWizard(Source, Gallery, Format, PlotBy, CategoryLabels, SeriesLabels, HasLegend, Title, CategoryTitle, ValueTitle, ExtraTitle)
expression A variable that represents a Chart object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Source |
Optional |
Variant |
The range that contains the source data for the new chart. If this argument is omitted, Microsoft Word edits the active chart sheet or the selected chart on the active worksheet. |
Gallery |
Optional |
Variant |
One of the XlChartType constants that specifies the chart type. |
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, Word 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 that specifies the number of rows or columns within the source range that contain category labels. Allowed values are from 0 (zero) through one less than the maximum number of the corresponding categories or series. |
SeriesLabels |
Optional |
Variant |
An integer that specifies the number of rows or columns within the source range that contain series labels. Allowed 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 the Source parameter is omitted and the selection is not a chart on the active document, this method fails and an error occurs.
Example
Note
Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.
The following example reformats the first chart as a line chart, adds a legend, and adds category and value axis titles.
With ActiveDocument.InlineShapes(1).Chart
.ChartWizard _
Gallery:=xlLine, _
HasLegend:=True, _
CategoryTitle:="Year", _
ValueTitle:="Sales"
End With