View Single Post
  #4   Report Post  
Alex St-Pierre
 
Posts: n/a
Default

I finally found the answer:

Make a copy - special paste with link.
After, select the chart and click Shift+F9 to see the link.
ex: { LINK Excel.Sheet.8 \\\\Worksheet.xls "sheet1![Worksheet.xls]chart
name" \a \p
You have to replace the second part of the equation by your field name.
Hope this help ;)
Alex

"Alex St-Pierre" a écrit :

Thanks Jon,

I use the chart in a mail merge document and I have a chart for each record
(about 2000). My first problem was to be able to merge a graphic simultaneous
during the merge process (link the charts directly from excel to word).
Somebody told me that is it impossible (binary transfer problem). He told me
to consult Cindy Meisters site Special Merges section (Graphic from a
database)
http://homepage.swissonline.ch/cindy...r/MergFram.htm

So, I have done a macro in excel which export each chart as gif and then,
import the picture in word using Include Picture method. This approach works
but is limited by .gif quality and so, the charts are not sufficient clear to
send to our customer. My friend told me that it looks like 80 charts ;)

As you said, the only way to achieve a great quality is to copy the chart
directly from excel to word. There is an article in Cindys site which looks
interesting:

(Mail merge to a chart article)
Word mail merge doesn't provide any way to generate a chart for each record
in a mail merge. There are four basic approaches you can use to create charts
for mail merge:
1- Create a chart for each record in Excel. Add a column to the data table
and enter the name of the appropriate chart for each record. Use this merge
field in LINK field in the mail merge document.

I have done all the steps except the last one. I have tried to copy the
chart and make a special paste with link but as the merge is generated, the
link is not updated. Do you know how to link the chart (function of a merge
field) to the mail merge document?

"Jon Peltier" a écrit :

Alex -

Exporting as any bitmap style (gif, png, jpg) will have the same resolution as your
monitor, and if not used at the same zoom, the bitmap will look bad. JPG files are
even worse, due to their poor rendering of sharp color transitions.

Where are the charts being used? If you are moving them into another program, try
copying in Excel as a picture, using the On Screen and As Picture options, then
paste into the target app. This copies the chart as the set of shapes that comprise
it, and these can be scaled continuously without the pixelation that spoils bitmaps.

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

Alex St-Pierre wrote:

What is the method to export Excels charts so that they
have the best possible appearance?

Default graphs in Excel show curves as line segments (jagged) that are
clearly visible. No graphic smoothness!

Is there any solution to control what is the resolution of the chart you
export in "gif" file?? My own solution is to enlarge the chart in excel
before exporting and then, reduce the size of the gif with photoshop. This
solution does not give good results. Any idea ??
Nota: I'm using office xp with the last updates.
Thanks,