Page 234 - Excel Progamming Weekend Crash Course

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

SESSION

17

Introduction to Charts

Session Checklist

✔ Chart sheets versus embedded charts
✔ Specifying data to be plotted
✔ Selecting chart type
✔ Adding chart and axis titles

✔ Working with fonts in a chart
✔ Using the ChartWizard method

xcel provides truly sophisticated charting capabilities. You can create a wide variety of
charts, including pie, line, and bar charts, as well as more specialized chart types such
E as radar, scatter, and doughnut charts. An Excel chart is linked to data in a worksheet
and automatically updates to reflect changes in the data. This session and the next show
you how to work with Excel charts in your VBA programs.

Embedded Charts and Chart Sheets

A chart can exist in a worksheet in two ways:
As an embedded chart in a regular worksheet, along with data and/or other embed-
ded charts.
On a chart sheet, which is a special kind of worksheet that holds a single chart and
nothing else.