I just happened to write an article about this recently. See Chart Events in Microsoft Excel. You will be taking advantage of the Chart_Select or Chart_MouseUp event.
Hi Jon,
I have read your post on chart events. Very informative. I'm currently working on a dashboard where if you click on the data label it will show a small data table. The problem is when I try to move the chart sheets to a single sheet they become regular charts. Is there a way to put multiple chart sheets on one page? Any advice would be greatly appreciated.
The same way you can embed a chart (chart object) on a worksheet, you can embed a chart (chart object) in a chart sheet. However, only the chart that is the chart sheet, and not any chart objects embedded in the chart sheet, are tied to event procedures in the chart sheet's code module. You would still need to set up a class module to capture chart events for the embedded charts in the chart sheet.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
