Microsoft Office Tutorials and References
In Depth Information
Figure 21-30. Illustrating the ChartWizard method
The PlotBy parameter specifies whether the data for each series is in rows or columns. It can be
one of the values xlRows or xlColumns .
The CategoryLabels parameter is an integer that specifies the number of rows or columns
within the source range that contain category labels. It can be any value from 0 through one less
than the maximum number of categories or series.
Similarly, SeriesLabels is an integer that specifies the number of rows or columns within the
source range that contain series labels. It can be any value from 0 through one less than the
maximum number of categories or series.
The HasLegend parameter should be set to True to include a chart legend.
The Title parameter should be set to the chart title text. Similarly, CategoryTitle is the
category axis title text, ValueTitle is the value axis title text, and ExtraTitle is the series
axis title for 3-D charts or the second value axis title for 2-D charts with a second value axis.
To illustrate, imagine that the chart in Figure 21-30 is the active chart The following code
reformats the chart in Figure 21-30 , as shown in Figure 21-31 :
ActiveChart.ChartWizard Gallery:=xlLine, _
Format:=1, HasLegend:=True, Title:="Averages", _
CategoryTitle:="Grades", ValueTitle:="Average".
Figure 21-30. Illustrating the ChartWizard method
Figure 21-31. Results of the ChartWizard method
21.16.2 Export Method
 
 
Search JabSto ::




Custom Search