I have a requirement where I need to export chart caption text into excel file along with chart data.
Using macro I am able to do that, but I have many charts within container which need to be export along with caption. Is there any way where I can include the scripts on XL icon of charts or something?
so that user do the usual export to excel on click of charts XL icon and caption get export along with data automatically based on the selected charts.
Appreciate if someone provides value addition suggestions.