I am exploring VBA in excel and would like to know how to get a hold of the Series and Point names from my stacked columns chart. If you have a stacked column, you can hover over any column and excel will show you a little text box with 'Series "< series-name >" Point "< point-name >" Value: ##'.
I would like to be able to either click or hover over any column in the chart and execute VBA code to find the series and point names. The most challenging task for me is to trigger the VBA script by a hover or mouse click and identify the active part within the active chart.
Any help is greatly appreciated!