Excel 2007 : How To Save Excel Chart As Image
Subscribe to the 
RSS Feed or by Email and receive free daily updates
This post demonstrates an easy way to save a chart in Excel 2007 as an image (png, jpg, gif, bmp etc.).
Create the chart based on the data in Excel.
Right click anywhere on the chart border and say “Copy”.
Now open paint (Start-> Programs -> Accessories -> Paint) and say Paste.
The chart will be pasted into paint and you can save it in any image format (supported by paint).
Popularity: 17% [?]
Subscribe to the RSS Feed or by Email and receive free daily updates
Could it be so simple? nope. did it once, then never again. no problem with the copy part, but paste was not an option in paint, until once it worked. then it kept trying to paste one chart image, never the next one I copied…. not sure how I got it to work one time, but still experimenting to try and get it to work again. I hate 2007! why can’t you just select the chart and save as html, republish chart like 2003? without saving all the damn white/black surrounding space. rrrrrggggg
I know this is childish way, Is there any expert way?
Save the chart as a web page. File/SaveAs WebPage. Choose CHART radio button.
This will save as HTM and add a folder with the image which wil be in GIF format.
While it does work, if you save on a different tab the image disappears. Annoying bug to be sure.
Copy the figure into PowerPoint, and then save it as an image file.
Easiest way to copy/paste a chart as an image in Office ‘07 (may work in ‘03 but I don’t have that installed):
1.) Right click anywhere on the chart border and say “Copy”.
2.) In any other Office ‘07 application (including Outlook), click the little down arrow under the “Paste” icon which will reveal the “Paste Special” function. You can choose from a handful of different image formats (sorry, no TIF).
3.) done.
last one is a good option but I’ve run into problems with both the simple (paint) way and this last one–with paint, the chart is part of a larger document, making it hard to paste and format around in a Word doc. With copy and pasting directly, when I try to reformat the chart in a Word document (like make it smaller), all elements of the chart then have to be reformatted, and sometimes it’s just impossible (at least with my skills) to get it right.
…
Thanks a lot for the Paint tip - this page is the first Google result for “save excel chart as image”
Copy into PowerPoint, zoom way out so you see a tiny slide, and resize the chart to huge proportions. The copy the chart, go to PHOTOSHOP (or GIMP) and create a new document. Hi-res!
This would work, but I found a better way to do it, by installing an add-in into Excel - available at this blog: http://peltiertech.com/WordPress/enhanced-export-chart-procedure/
Paste it into word file which is previously save in Ms office 2003,…it will really work
Thanks for all the ideas. The “Paste Special” into Word 2007, choose “Picture (Windows metafile)” gives the cleanest look. You then have to right click, “Format picture” and click on “Fill”. Fill the background with white, or whatever color, otherwise, if you copy it and paste into PowerPoint it will be transparent (unless that is what you want. Of all the ways listed in this chat, this has worked the best for me.
Alternatively, stop using this crappy Excel for graphs, use Gnumeric instead (free open-source).
With a simple right-click on the graph, it can export your graph in a number of format: JPG, PNG, but also in SVG and PNG which enables you scale the exported graph without messing up the fonts etc.
I was using gnumeric and was quite happy with it. You can have a really high resolution with the image export!
The only thing why I am now using Excel is that in gnumeric I could not maket he lines of error bars as thin as I wanted. Then even a 900 dpi resolution doesn’t make any sense…
I tried it with Paint.NET and it worked fine. The only thing is the pasted image shows up with the 8 resizing nodes so you have to crop it a bit to get rid of them.
[...] a straightforward method to get that done, but I did not find anything that could really work. This page summarizes some ideas, whereas most of them are weird and don’t produce any output that can [...]