Save a chart as a TIFF (or other graphic file)?

[Guest]

Hi All,

I'm an introductory Excel user. I've created some charts that I'd like to
use in poster production, but I don't see how to save a chart as a TIFF or
JPG. Can this be done without buying a 3rd-party solution?

My workaround has been to display the chart as large as possible, the copy &
paste into a graphics program. Is there a better way?

Thanks in advance!

 

[Guest]

hi,
At the bottom of the save as box in the file type box are
your save options. tiff and jpg are not one of them.

 

[Guest]

Thanks for the confirmation. I wonder how others
deal with this? I can't be the only Excel user who
has charts that need to be converted to graphic
files.

 

[Don Guillett]

try these

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

 

[Gord Dibben]

You could copy the chart and paste to a graphics program.

You could use VBA.

Sub SaveAsGIF()
' Saves the active chart as a GIF file
' Prompts for a file name and directory
Dim FileName As Variant
If ActiveChart Is Nothing Then
MsgBox "Select a chart to export."
Else
FileName = Application.GetSaveAsFilename( _
InitialFileName:=ActiveChart.Name & ".gif", _
FileFilter:="GIF Files (*.gif), *.gif", _
Title:="Save chart as GIF file")
If FileName <> False Then ActiveChart.Export FileName, "GIF"
End If
End Sub

Gord Dibben Excel MVP