How do I export a chart as a png in Excel 2010?

Question

Given a chart (normal column chart of whatever), how do I export that chart and only that chart as a PNG?

score 18 · Accepted Answer · edited May 02 '14 at 08:30

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.

score 3 · Answer 2 · answered Aug 27 '12 at 11:37

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:

PNG
JPEG
GIF
EMF
BMP
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.

score 2 · Answer 3 · answered Jun 18 '16 at 10:59

2

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.

answered Jun 18 '16 at 10:59

bovender

141

score 1 · Answer 4 · edited Oct 19 '12 at 15:32

1

Try VBA:

When on the active chart click ALT+F11 or CTRL+G

and type:

Activechart.export "D:\chart.png" (use relevant file location - avoid the system partition)

You can change the file extension as you wish (png, jpeg etc.)

edited Oct 19 '12 at 15:32

answered Oct 19 '12 at 14:19

Tom Sti

36
2

score 0 · Answer 5 · edited Apr 13 '17 at 12:22

0

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.

edited Apr 13 '17 at 12:22

Community

1

answered Sep 16 '16 at 06:23

John Forbes

131

score 0 · Answer 6 · answered May 01 '19 at 00:34

For Ubuntu with Excel 2010 on POL/Wine:

Select chart Home->Copy or Ctrl-c. Note that Home->Copy as Picture option 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 File->Export and set the file name and format.
LibreOffice Draw: Select the pasted image, Right-Click->Save Image

How do I export a chart as a png in Excel 2010?

6 Answers6

Linked