My requirement is to provide user to select the export option up on hovering the chart/button to PDF and power point , on each chart or on all selected charts on a sheet into one file.
Please note that having an export option upon hovering the chart is not a user-friendly approach as a tooltip or dialog window would prevent the user from viewing the chart.