Skip to content

Exporting an Excel 2007 chart as an image in Windows 7


You may also have come across this problem: you've made a nice chart in Excel, and now you want to use it elsewhere.

So you right click and look for 'Save as Image'. It's not there!

If you want to use it in Word, or PowerPoint, your only choice is to copy and paste which is OK - but it has its problems. If you've inserted a text box, it doesn't resize with the chart. And you can't do things that you can do with an image, such as resizing it using the Size function, rotate it, etc.

And what if you want to upload it to your website??

The only other native option then is to do a print screen and fiddle around in Paint, or use the Snipping Tool (Vista or Windows 7) which is similar, but easier.

However, there is another solution: an Export Chart add-on to Excel written by Jon Peltier - what this does is add an extra function to Excel that exports your charts as .png images (though you can change that if you write a different extension, such as .jpg).

The link is down at the bottom of the post, and he also links to a page to explain how to install it.

Very useful and recommended.


The 15-minute blog post.
I like to blog, but I can't afford to spend a lot of time on it. Solution: limit myself to 15 minutes per post.
One link, one picture maximum.
All comments, critiques and corrections are welcome. Thank you.

Free software

I learnt about this very useful site the other day – it’s called Giveaway of the Day and the principle is very simple: every day one program is made available for free.

You have to download AND install it the same day (which I didn’t know at first and so missed a useful looking program). The programs are all bona fide software without any adware or spyware or anything.

Seems too good to be true almost… but so far it all seems totally legit. The programs are usually the relatively basic, stripped down versions, and they do not offer any free updates or support.

Once you download and install it, you run a little activation key program that gives you the serial number.

Today I downloaded the one in the picture above – could come in use for my research: how many times have you wished you were able to record things on YouTube, for example? Continue reading "Free software"