Graph to TIF

[jee22]

Does any one know how to convert an Excel graph into a tiff file please


--


_____________________________________________
_____________________________________________
Mr J E Ellis
University of Cambridge
Department of Materials Science & Metallurgy
Pembroke Street
Cambridge
CB2 3QZ
England
Tel + 44-(0) 1223 334346
Fax + 44-(0) 1223 334567
E-mail (e-mail address removed)
_____________________________________________

 

[Don Guillett]

This works with either gif or jpg so I assume it should work for tif.

Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\yourfolder\MyChart.gif", _
FilterName:="GIF"
End Sub

 

[Stephan Kassanke]

Does any one know how to convert an Excel graph into a tiff file please


--

Hi,

just select your chart in Excel, copy it to the clipboard, open Photoshop
(or whatever imaging software you are using), create a new file and paste
your chart. Just tried it with Photoshop and it works.

Another approach is to save the chart as a web page (File/Save as). Thsi
should render your chart as a btmap file (jpeg, png, ...)

cheers,
Stephan

 

[jee22]

Thanks to both of you

 

[Don Guillett]

glad to help