exporting charts

[chico]

How to export a chart and use it in other applications like MS Word and
others? Thanks

 

[Don Guillett]

A possible solution

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

 

[Jon Peltier]

For example:

Copy the chart in Excel, switch to Word, use Paste.

Select the chart, hold shift while clicking the Edit menu, Copy Picture (on
screen and picture options), switch to Word, use Paste.

- Jon

 

[chico]

Thanks man, very useful.

For example:

Copy the chart in Excel, switch to Word, use Paste.

Select the chart, hold shift while clicking the Edit menu, Copy Picture
(on screen and picture options), switch to Word, use Paste.

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