Chart Events

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

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

Event Trigger

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?

0 0
Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook

Post a comment