Microsoft Office Tutorials and References
In Depth Information
As in the previous example, the key component in this procedure is the
GetChartElement method. If ElementId is xlSeries , then the mouse pointer is
over a series. The NewText variable then is assigned the text in a particular cell.
This text contains descriptive information about the data point (see Figure 16-21).
If the mouse pointer is not over a series, then the text box is hidden. Otherwise, it
displays the contents of NewText .
Figure 16-21: Range B7:C9 contains data point information
that’s displayed in the text box on the chart.
Search JabSto ::

Custom Search