Page 250 - Excel Progamming Weekend Crash Course
P. 250
n540629 ch18.qxd 9/2/03 9:35 AM Page 225
SESSION
18
Advanced Charting Techniques
Session Checklist
✔ Naming and referencing charts
✔ Preventing user changes by locking charts
✔ Working with the ChartObject object
✔ Using scatter charts
✔ Printing charts
he previous session provided an introduction to Excel charts and techniques for creat-
ing and manipulating them from VBA programs. More advanced chart programming
T techniques are covered in this session.
Naming and Referencing Charts
A chart sheet is automatically assigned a name when created. These default names take the
form of Chart1, Chart2, and so on. Likewise, embedded charts are assigned names, but the
situation is a bit more complicated:
The differences between embedded charts and chart sheets are covered in
Session 17.
Cross-Ref
The ChartObject is assigned a name in the form of Chart 1, Chart 2, and so on.
Note that there is a space before the number.
The Chart object is assigned a name that combines the name of the worksheet it is
on with the name of the ChartObject in which it is contained — for example,
Sheet1 Chart 13).
