Given a chart (normal column chart of whatever), how do I export that chart and only that chart as a PNG?
You can't do this directly from Excel; you need to use an external application:
Select the chart, and then copy it to the clipboard (Ctrl-C).
Open a picture editor that supports saving to PNG.
Do a paste in the picture editor (when copying the chart from Excel 2010, it is recognized as a valid picture on the clipboard). The best will be to paste as new image if the picture editor supports that.
Save as PNG.
If you're working within the Office environment you don't need any other software, all you need to do is select & copy your chart then choose the
Paste Special option. One of those paste options is PNG. The others include:
- Microsoft Office Drawing Object
If you need to export outside of the Office environment, then you can use Office Picture Manager. Just paste your chart inside your My Pictures folder (or whereever is most convenient). My charts paste as PNG by default, but if yours don't, you can choose your image and
File>Export and choose your file type, inlcuding PNG, from the list.
There's a free, open-source Excel add-in to accomplish that, "Daniel's XL Toolbox" (https://www.xltoolbox.net).
Disclaimer: I'm the author of that tool.
I usually go via printing/exporting to pdf first as I cannot see how to achieve print quality via the default export methods mentioned above. Once exported to pdf you can export to the desired image format from there via snipping tool or pdf to png command e.g. https://askubuntu.com/questions/50170/how-to-convert-pdf-to-image/50180.
For Ubuntu with Excel 2010 on POL/Wine:
- Select chart
Copyor Ctrl-c. Note that
Copy as Pictureoption does not work for me so first try with the standard copy.
- Open Gimp from the Dash. If you don't have Gimp installed, you can use LibreOffice Draw.
- Press Ctrl-v to paste.
- For Gimp: use
Exportand set the file name and format.
- LibreOffice Draw: Select the pasted image, Right-Click->