email charts

M

MNaut

I have an excel workbook file containing many department sales charts that
recieve data from a group of central data entry spreadsheets. Each
department chart resides on its own sheet. Is there a way to email
individual chart sheets (or snapshots of the chart sheet) to the respective
departments without sending the entire parent file to all recipients?
Thanks,
Mnaut
 
D

Debra Dalgleish

You could export the chart as a gif file, then email that file to the
department. The following code creates a gif file from the active chart:

'============================
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\Data\DeptChart.gif", _
FilterName:="GIF"
End Sub
'=============================
 
Top