Someone in my company came across a requirement for exporting charts in Microsoft Excel. It was then that he came across some automation for the same. He got a tool for himself, but it was quite buggy and very small in features. It was then that I thought of creating one for myself and what I could see was that there are tools available in the market, but people have kept the code password protected and licensed. I thought of making an excel add-in and making the keeping the code open for use.
I have used the “Sheets ().ChartObjects(i).Chart.Export ” to export the charts in excel. Please download the OpenChartExporter add-in here. It is simple to use.