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: 8% [?]
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.
…