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

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

--
Don Guillett
SalesAid Software

"chico" wrote in message
...
How to export a chart and use it in other applications like MS Word and
others? Thanks

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
_______


"chico" wrote in message
...
How to export a chart and use it in other applications like MS Word and
others? Thanks

Thanks man, very useful.

"Jon Peltier" wrote in message
...
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
_______


"chico" wrote in message
...
How to export a chart and use it in other applications like MS Word and
others? Thanks

There are two ways of creating charts:

1. Creating a Chart as Object - Using Microsoft Graph Chart.
2. Creating a chart in excel - using the Chart Wizard within Excel.

Descriptions:

A. Using the first option, you can just copy and paste in the application.
This will be independent of the source document.

B. Using second option, you can paste the graph in the Word document using
the paste link command from the Edit menu.
The advantage is whenever you change the Chart type or choose any Chart
Sub-type or Choose Custom Type tab, the charts automatically reflects the
changes in the Word document with the same size of the image you have resized
int word document.

(For example, If you change your bar chart to Pie Chart, the Microsoft
document would automatically the Pie Chart now.).

Challa Prabhu

"chico" wrote:

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