Microsoft Office Tutorials and References
In Depth Information
Saving a Chart as a Graphics File
Saving a Chart as a Graphics File
Oddly, Excel doesn’t provide a direct way to convert a chart into a stand-alone graphics file, such
as a GIF or PNG file. In this tip, I present three methods for saving an Excel chart as a graphics file
(one method uses a VBA macro).
Method 1: Paste the chart into a graphics program
This method requires other software — namely, a graphics program. Select your chart and
choose Home
Clipboard
Copy (or press Ctrl+C). Then access a document in your graphics
pro➜
gram and choose Edit
Paste (or its equivalent command). Then you can save the file by using
whichever graphics file format you like.
You might need to experiment to get optimal results. For example, you might need to copy the
chart as a picture. To do so, select the chart and then choose Home
Clipboard
Copy
Copy As
Picture.
If you don’t have a graphics program, try IrfanView, available free at http://irfanview.com .
Method 2: Save as an HTML file
To convert all charts in a workbook to PNG files, save your workbook in HTML format and then
locate the PNG files that are created. Follow these steps:
1. Save your workbook.
2. Choose File
Save As.
3. In the Save As dialog box, choose Web Page (*.htm, *.html) from the Save As Type
drop-down list.
4. Choose the Entire Workbook option.
5. Select a location for the file.
Your desktop is a good choice because it’s easy to find.
6. Provide a name for the file and click Save.
7. Close the workbook.
8. Open an Explorer window and locate the folder where you saved the file.
9. In addition to the HTML file, you’ll find a subdirectory with a name that corresponds to
the filename with _files appended; open that folder to see a PNG file that corresponds to
each chart in your workbook.
 
Search JabSto ::




Custom Search