The Chart object has several events that are triggered by various user actions. Some of the events are familiar—like Activate(), MouseDown(), and MouseUp()— but a few are unique to the Chart object. Table 9.3 summarizes the less familiar events associated with the Chart object.
Chart object events are not automatically enabled with embedded charts. Although Chart object events can be enabled for embedded charts, the methods involved are beyond the scope of this book.
Table 9.3 Chart Object Events
Calculate When new or changed data is charted
DragOver When a range of cells is dragged over a chart
DragPlot When a range of cells is dragged and dropped on a chart
Resize When the chart is resized
Select When a chart element is selected
SeriesChange When the value of a charted data point changes
Was this article helpful?