Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

How to convert excel chart into a Jpeg or Gif or BMP

Posted by Abid on June 21, 2001 4:07 AM
Hi all,

I want to convert a chart in excel sheet into any grpahic format. (BMP, JPEG, GIF are preferred). Can some one tell me how I can accomplish this task. I've checked the saveas method of ActiveChart but it save to none of the graphics format.

Thanks in advance,

Abid.
SofPak Inc.


Re: How to convert excel chart into a Jpeg or Gif or BMP

Posted by Ben O. on June 21, 2001 5:39 AM
What I usually do is take a screen shot by pressing the PrintScrn button, and then paste the screen shot into an image editor, like Paint Shop Pro or Photoshop. If you don't have either of those, you could use Windows Paint.

Once you have the screen capture in your editor, crop the image to your chart, then save it in whatever format you want.

There is an Excel Add-in that let's you export charts as .gifs. Check Mr. Excel or Aaron Blood's site (can't remember the address) for it.

-Ben


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.