Microsoft Office Tutorials and References
In Depth Information
Chart event procedures
Figure 16-18: An event macro, executed when any cell on the sheet is changed,
modifies properties for the chart’s Value axis.
Chart event procedures
The preceding examples use an event associated with a worksheet. Chart sheets also
have events, and these are listed in Table 16-1.
T ABLE 16-1 EVENTS RECOGNIZED BY THE CHART OBJECT
Event
Action that triggers the event
The chart is activated.
Activate
An element in the chart is double-clicked. This event occurs
before the default double-click action (displaying the Format
dialog box).
BeforeDoubleClick
An element in the chart is right-clicked. The event occurs
before the default right-click action (displaying a shortcut
menu).
BeforeRightClick
The chart receives new or changed data.
Calculate
The chart is deactivated.
Deactivate
Continued
Search JabSto ::




Custom Search