Page 248 - Excel Progamming Weekend Crash Course

n540629 ch17.qxd 9/2/03 9:35 AM Page 223

Session 17 — Introduction to Charts 223

SeriesLabels. The number of rows (if PlotBy = xlRows) or the number of columns
(if PlotBy = xlColumns) containing data series labels.
HasLegend. True to include a legend; otherwise False. The default is True.
Title. The text of the chart’s title. Optional; the default is no title.
CategoryTitle. The text of the category axis title. Optional; the default is no title.
ValueTitle. The text of the value axis title. Optional; the default is no title.

REVIEW
This was the first of two sessions on creating Excel charts from your VBA programs.

An Excel chart can be by itself on a chart sheet or embedded as part of a regular
worksheet.
Data to be charted is arranged in data series and categories.
A chart can be any one of many types supported by Excel.
You can add titles to the chart itself and to the chart axes.
The font of all text in a chart can be modified.
The ChartWizard method combines several steps of creating a chart into a single call.

QUIZ YOURSELF
1. How many charts can you place on a chart sheet? (See the “Embedded Charts and
Chart Sheets” section.)
2. What happens if an embedded chart is placed on top of data in a worksheet? (See
the “Embedded Charts” section.)
3. What text does Excel use as the default chart title? (See the “Displaying Chart
Titles” section.)
4. What is plotted on the horizontal axis of most Excel charts — the data series or
the categories? (See the “The Chart Object” section.)
5. What property would you use to change the font of the chart title? (See the
“Working with Fonts in a Chart” section.)