best way to export chart

R

Richard

How do I convert Excel charts into graphic files, like .gif or .jpeg ?

Macro would be best - where I could specify resolution, and make .gif files
for all graphs in a given workbook. This way I could easily make small files
for web, and higher resolution files for printing.
 
W

widman

There may be a better way, but I find it best to figure out the best size in
Excel itself, as the words and boxes move around a bit and lose form when
resizing.

then you can either copy (clicking so the whole chart is selected) and paste
into another document, or I frequently use the "PrtScr" and paste into
photoshop.
 
D

Don Guillett

use either of these ideas. If you want to do all incorporate into a for/next
loop

Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub
Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub
 
R

Richard

Works fine.
..Gif is smaller file, yet looks better - so I will go with .gif

Is there anyway to select export file resolution?
 
Top