In this article, we will discuss how to create a chart and change the series & it’s value on mouse hover. Though, there is no Mouse Hover event in Excel however, we will use an alternate method to simulate Mouse Hover event and change the series of a line chart. You can apply the same tips for other charts or calculation in Excel.
![Internactive Chart 3](https://thedatalabs.org/wp-content/uploads/2020/07/Internactive-Chart-3-1024x492.png)
Below is the snapshot of data which has been used in this chart. This is the zone-wise sales performance data from Jan to Dec.
![Raw Data](https://thedatalabs.org/wp-content/uploads/2020/07/Raw-Data.png)
Have created a support table for line chart.
![Support Data](https://thedatalabs.org/wp-content/uploads/2020/07/Support-Data.png)
Insert a line chart on the support table and format the chart and move to first worksheet.
Jump to visual basic application window and insert a blank module. Create a User Defined function.
![Code](https://thedatalabs.org/wp-content/uploads/2020/07/Code.png)
Now, move to Excel window and create labels for North, South, East and West.
![Labels](https://thedatalabs.org/wp-content/uploads/2020/07/Labels.png)
User the Hyperlink formula and pass the user-defined function as a parameter in Hyperlink function. Refer the below mentioned formula for North. Replicate the same for other zone as well.
=”North” & IFERROR(HYPERLINK(MouseHover(“North”),””),””)
Now, our interactive chart is done.
Please watch this step by step tutorial on YouTube.
Please click on below button to download the excel file used in this tutorial.
![Download](https://thedatalabs.org/wp-content/uploads/2019/04/Download-e1574918596847.png)