Easy method for exporting charts to other formats
Currently it is not possible to easily export excel charts to other formats (e.g. png, eps, pdf, etc.) even in the excel 2016. The ability to do so easily (via the context menu for example) without the need to use any external software would be so handy.
Today, this can be done via a VBA macro. However, we can definitely see the value in doing this through the UI. We’ll consider this in our future planning.
We’ll be posting to the Excel UserVoice home page, the features which we’ll be implementing in the near future. To be clear though, we are focusing on features which have the highest customer interest which typically have hundreds of votes.
This should probably be merged with https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/17133787-svg
That would increase the vote count too.
Richard Sigal commented
Ability to export graphs in formats such as TIFF. When preparing scientific papers the publishers often ask for such formats.
John Dangerbrooks commented
A strong web presence often needs charts to be displayed. Charts are best represented in a scalable format like SVG. Currently, Excel only supports bitmap, which cannot be easily scaled.
This should be as easy as a right click / [Export as...] / [menu with formats]. That command should create a file in the workbook's path with the name [Workbook name] - [Chart title].[Selected format]. Then a Windows explorer window should open with said file selected.
Scott, even the VBA macro method of exporting charts needs improvement. Exporting via Chart.Export results in dithered colors, even when using PNG format. The only reliable way to get undithered charts is to copy the chart and then paste into an image editor, which is a tedious and repetitive task when you have many charts to deal with.