Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
add comment

3 Answers

up vote 8 down vote accepted
  1. Select the chart, and then copy (Ctrl-C).

  2. Open a picture editor that supports saving to PNG.

  3. 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.

  4. Save as PNG.

share|improve this answer
    
I think it's most easiest way to do that, there another method to do this is write VB script –  Ishikawa Yoshi Aug 27 '12 at 9:03
add comment

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.

share|improve this answer
add comment

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.)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.