e-mailing or exporting charts as a .pdf or .tif format

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Hi all. I have a question on printing our charts. I can
print out a chart on a printer and scan the printed chart
to get a .pdf or a .tif file format. Is there a way to
export a chart in these formats? Other formats like .bmp
or .jpeg?
 
You need software that specifically converts to PDF to get into PDF format.
For a tif file, I'd try copying the picture from Excel (Shift Edit Copy
Picture) into drawing software (Paint has tif) and saving it from there.
 
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
 
I wish I'd known about this months ago. It would have saved me a lot of
time. Thanks!
 
You can also use TIF and PNG formats. I usually tell people to avoid
JPGs for their charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top