Microsoft Office Tutorials and References
In Depth Information
Figure 1-3. Select Special dialog
In this topic, we will develop a simpler version of this utility, whose dialog is shown in Figure 1-3 .
This topic will also supply you with the necessary knowledge to enhance this utility to something
similar to the utility shown in Figure 1-2 .
Figure 1-3. Select Special dialog
1.2 Setting a Chart's Data Point Labels
As you may know, data labels can be edited individually by clicking twice (pausing in between
clicks) on a data label. This places the label in edit mode, as shown in Figure 1-4 . Once in edit
mode, we can change the text of a data label (which breaks any links) or set a new link to a
worksheet cell. Accomplishing the same thing programmatically is also very easy. For instance,
the code:
 
 
 
Search JabSto ::




Custom Search