Page 262 - Excel Progamming Weekend Crash Course

n540629 ch18.qxd 9/2/03 9:35 AM Page 237

Session 18 — Advanced Charting Techniques 237

REVIEW
Excel’s charting capabilities are powerful, and you can access all this power from your VBA
programs.
You can assign names to charts and then later refer to the chart by this name.
By protecting or locking a chart, you can prevent the user from modifying it.
You use the ChartObject object to control certain aspects of embedded charts,
including their size and position.
The scatter chart is specialized for plotting values versus values.
Use the PrintOut method to print charts.

QUIZ YOURSELF

1. How is the default name assigned by Excel constructed for an embedded Chart
object? (See the “Naming and Referencing Charts” section.)
2. Suppose you have password-protected a chart and then realize you have lost or
forgotten the password. What can you do to modify the chart? (See the “Locking
Charts” section.)
3. How would you determine the range of worksheet cells over which an embedded
chart is displayed? (See the “The ChartObject Object” section.)
4. Some scatter chart types are smoothed. What does this mean? (See the “Scatter
Chart Types” section.)
5. Is there a direct way to access all of the embedded charts in a workbook? (See the
“Naming and Referencing Charts” section.)