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

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.

"Brad" <[email protected]> wrote in message
news:[email protected]...
> 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?

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

--
Don Guillett
SalesAid Software
[email protected]
"Brad" <[email protected]> wrote in message
news:[email protected]...
> 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?

Brad,

John Walkenbach offers a free add-in at his Spreadsheet Page site that
allows you to export charts in a GIF, JPG, TIF, or PNG format. Here is the
URL to the page that discusses the tool:

http://j-walk.com/ss/excel/files/charttools.htm

----
Regards,
John Mansfield
http://www.pdbook.com


"Brad" wrote:

> 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?
>

I wish I'd known about this months ago. It would have saved me a lot of
time. Thanks!

"John Mansfield" <[email protected]> wrote in message
news:[email protected]...
> Brad,
>
> John Walkenbach offers a free add-in at his Spreadsheet Page site that
> allows you to export charts in a GIF, JPG, TIF, or PNG format. Here is
> the
> URL to the page that discusses the tool:
>
> http://j-walk.com/ss/excel/files/charttools.htm
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
>
> "Brad" wrote:
>
>> 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 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/
_______

Don Guillett wrote:

> 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
>