These code are to export a chart from Excel to .png and .pdf extensions.
go to Tools > Macro > Visual Basic Editor.
- In the new window, select Insert > Module and copy some from codes available (SaveSelectedChartAsPDF or SaveSelectedChartAsImage) or in the blank page.
- Then go to File > Close > Return to Microsoft Excel
- Select a chart that you want to export
- Tools > Macro > Macros, then select SaveSelectedChartAsPDF or SaveSelectedChartAsImage and press Execute.