Microsoft Office Tutorials and References
In Depth Information
21.16.1 ChartWizard Method
Floor
Floor
Hyperlinks
Hyperlinks
Legend
Legend
Line3DGroup
ChartGroup
LineGroups
ChartGroup(s)
Location
Chart
OLEObjects
OLEObject(s)
PageSetup
PageSetup
Pie3DGroup
ChartGroup
PieGroups
ChartGroup(s)
PlotArea
PlotArea
RadarGroups
ChartGroup(s)
SeriesCollection
Series/SeriesCollection
Shapes
Shapes
SurfaceGroup
ChartGroup
Walls
Walls
XYGroups
ChartGroup(s)
Let us discuss a few of the members of the Chart object. (We have encountered many of these
members in connection with other chart-related objects.)
21.16.1 ChartWizard Method
The ChartWizard method modifies the properties of a chart. Note that, unlike the PivotTable
wizard, the ChartWizard method does not create a chart. The ChartWizard method is useful for
applying several formatting properties to a chart at one time. The method changes only the
properties that are specified by the parameters that are included in the call to the method.
The syntax for the ChartWizard method is:
ChartObject .ChartWizard( Source , Gallery , Format , _
PlotBy , CategoryLabels , SeriesLabels , HasLegend , _
Title , CategoryTitle , ValueTitle , ExtraTitle )
Note that all parameters are optional.
The Source parameter is the range that contains the source data for the chart. If Source is
omitted, then Excel will use the selected embedded chart or the active chart sheet. If no embedded
chart is selected and no chart sheet is active, then an error will result.
The Gallery parameter specifies a general chart type and can be one of the following
XlChartType constants: xlArea , xlBar , xlColumn , xlLine , xlPie , xlRadar ,
xlXYScatter , xlCombination , xl3DArea , xl3DBar , xl3DColumn , xl3DLine ,
xl3DPie , xl3DSurface , xlDoughnut , or xlDefaultAutoFormat .
The Format parameter specifies the specific chart type, given the value of Gallery . The value
of Format can be a number from 1 through 10, depending on the gallery type. Note that this value
corresponds to the chart types in the Chart Format dialog. If this argument is omitted, Excel will
select a value based on the gallery type and data source.
Search JabSto ::




Custom Search