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.

--
Richard

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.

"Richard" wrote:

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.

--
Richard

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

--
Don Guillett
SalesAid Software

"Richard" wrote in message
...
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.

--
Richard

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

Is there anyway to select export file resolution?
--
Richard


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Richard" wrote in message
...
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.

--
Richard

I think you will have to change in another program.

--
Don Guillett
SalesAid Software

"Richard" wrote in message
...
Works fine.
.Gif is smaller file, yet looks better - so I will go with .gif

Is there anyway to select export file resolution?
--
Richard


"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"Richard" wrote in message
...
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.

--
Richard