9.4 Formatting the components

Formatting the components

The GraphWizard method goes only so far in setting up a graph. Many clients are familiar with the graphs that Excel can produce and ask for many of those features. They ll ask you to move the legend to the other side, make the font bigger on the axis labels, add grid lines, change the colors (of everything clients love to insist on color changes), and so on.

The following topics generally are organized to correspond to objects and collections that are part of the chart. Some objects, such as the SeriesCollection, are always available. Others, such as Title objects, are only available if a particular property, such as HasTitle, is set to true.

Whether you are building the chart from scratch or are modifying one built by the ChartWizard, you ll find what you need in the following topics. We ve organized the rest of this chapter to start with a discussion of the Chart object s properties and methods, and then we ll work through the Chart object s subordinate objects.

 

Copyright 2000 by Tamar E. Granor and Della Martin All Rights Reserved