I still receive a lot of hits for my earlier post about how to export Excel charts to PDF in order to include them in a LaTeX document. Various keywords also indicate that a lot of people want to kind of automate that process and export many charts at once. Luckily that is also possible now. I have not checked for the PC version yet (if you do it would be great if you could tell me in the comments or view some other channel but here is how-to for Microsoft Excel 2011 for the Mac:
Create your charts (that step should be obvious)
Select all your charts (hold shift and click):
Select “Save as Picture” from the context menu
Check the Box “Save each graphic as a separate file” and select format PDF:
- .pdf”. So for example “Charts”: [
This works similarly in Microsoft Word and Microsoft Powerpoint.