Microsoft Office Tutorials and References
In Depth Information
USING THE MOUSEOVER EVENT
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.