Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 04, 06:49 PM
Alex St-Pierre
 
Posts: n/a
Default Chart appearance using "export" method

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,
--
Alex St-Pierre

  #2   Report Post  
Old December 1st 04, 06:13 AM
Jon Peltier
 
Posts: n/a
Default

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,


  #3   Report Post  
Old December 1st 04, 04:09 PM
Alex St-Pierre
 
Posts: n/a
Default

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 Meister’s 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 Cindy’s 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,



  #4   Report Post  
Old December 1st 04, 08:37 PM
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 Meister’s 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 Cindy’s 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,



  #5   Report Post  
Old December 3rd 04, 03:29 AM
Jon Peltier
 
Posts: n/a
Default

Alex -

This is new to me too. What part of the link must one replace? Better still, could
you post what the complete field codes were before and after changing them?

Thanks,

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

Alex St-Pierre wrote:

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 Meister’s 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 Cindy’s 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,





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart newbie help, please, How to create JohnT Charts and Charting in Excel 3 November 30th 04 04:17 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 1 November 29th 04 11:21 AM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM
Hiding or Displaying Series In a Chart SPYREN Charts and Charting in Excel 1 November 27th 04 12:49 PM


All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017