The chart object has a number of events.

We can write Excel VBA code to run when the user performs a specific action on an embedded chart for embedded charts.

Events include the mouse down event.

The mouse down event is triggered when a chart element is left clicked.

Calculate the calculate event is triggered when new or changed data is plotted on our chart.

In order to use events within an embedded chart, we must do the following.

Firstly, create a class module.

Secondly, declare a public chart object.

Then connect the declared object with our chart, and then finally select the new object in the object box and the desired event from the procedure dropdown.

We have some notes on the required syntax so that we can apply this to create our interactive chart.