My experience is similar. I have need to export flow charts from Excel 2007
to Word and/or Scientific Word in such a way that the graphic looks crisp and
clean and professional both on screen and in print (e.g., at least 300dpi and
without a lot of conversion artifacts and raster jagginess). Since different
applications don't necessarily display things in the same way it is also
helpful if the graphic can be resized gracefully and is not going to be a
huge file. For these reasons, a vector format is preferred rather than
bitmapped.
These are the methods I have tried and the problems encountered:
1. Home Paste Menu As Picture Copy as Picture As Show on Screen
Bitmap
This works best but the resolution is not very good. This method produces a
graphic which is adequate in the sense that it is legible (in some cases
barely so) but it certainly does not look crisp, clean, or professional.
2. Home Paste Menu As Picture Copy as Picture As Show on Screen
Picture
This method introduces distortions and makes unusable and/or illegible
graphics. Some elements move with respect to others and are in the wrong
place. The kerning is trashed on text so the letters are randomly too close
together or too far apart. Sometimes it looks like Courier is being used
instead of the original font. There are all kinds of aliasing problems so
that lines are sometimes very thick sometime very thin when they were all the
same thickness in Excel.
3. Home Paste Menu As Picture Copy as Picture As Show when printing
This method produces a picture which prints entirely black and/or shows up
entirely black on screen. I'm guessing this is some kind of misunderstanding
related to background opacity, but clearly this renders the graphic
completely unuseable.
4. Direct copy/paste from Excel to Word produces the same results as #2 and
to Scientific Word produces the same results as #3.
5. I have not tried the export to html option as that seem to have a limit
of 120 dpi for the resolution setting since it is tailored to on-screen
applications, naturally enough.
I realize this is not an easy problem, but the straight copy/paste option
(#4) worked quite well in Office 2003. Although the resolution may not have
been 300dpi, I was not moved to check the actual resolution because the
graphics looked good. I have not yet found a way to get acceptable quality
for exported graphics in Office 2007.
Hopefully this will improve soon. Best of luck to anyone struggling with
this. Please let us all know if you find a better way....
Melissa
"Jon Peltier" wrote:
If it's any consolation, I have not been satisfied with Copy Picture in
Excel 2007. The Bitmap format seems to be the best format to use, because
the Picture format ends up with lots of misaligned elements within the
chart. Also, elements from a chart copied as a picture which in the past
could be ungrouped to separate into single shapes now remain somehow grouped
together. For example, the gridlines cannot be decomposed further than a set
of lines. Also the antialiasing of the elements as seen on screen in Excel
is reproduced in the target app when pasted as a picture, which means they
look wrong when moved slightly.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"artemis" wrote in message
...
Mike, Yes to the Excel 2003 commands. In Excel 2007 I have tried every
combination of Copy as Picture and in Word 2007 every combination of
Paste and Paste Special.
Adrienne
On Mar 24, 7:53 am, "Mike Middleton" wrote:
artemis -
Please verify:
InExcel2003, you select the cells, hold down the Shift key, and choose
Edit |CopyPicture(As shown on screen,Picture). In Word 2003, at an
insertion point, you choose Edit | Paste. Or, in Word2007, you choose Home
| (Clipboard) Paste.
InExcel2007, you select the cells, choose Home | (Clipboard) Paste |
AsPicture|CopyasPicture(As shown on screen,Picture). In Word 2003, at an
insertion point, you choose Edit | Paste. Or, in Word2007, you choose Home
| (Clipboard) Paste.
- Mike Middletonhttp://www.DecisionToolworks.com
Decision Analysis Add-ins forExcel
"artemis" wrote in message
...
By way of background, there are multiple charts on a page, with a
separate header which is apicture. The charts have no borders and
'float' on a grid which is the same colour as the chart area. The grid
has borders roundgroupsof cells and these form the borders for the
charts. (This makes it easy to line up charts - otherwise a very
frustrating business. It also makes it easy to resize all charts at
once by selecting all rows or all columns and adjusting them all
together, eg to fit to a page.) I select the underlying grid, together
with the charts on top and thepictureheader - that whole thing is
what I want to paste. There are usually about 10 charts to a page -
each row has some text on the left hand side, a pie and a column
chart.
InExcel2003 I've usedcopyaspicturewith no issues at all - all
copies over to Word perfectly. In2007most of the charts drop off
when pasted across to Word, usually two sets of charts remain with the
remaining 'picture' just the blank / coloured underlying grid of
cells. The text on the left hand side and the headercopyover fine.
I've tried all the combinations ofCopyasPicture/ Paste Special
with no luck.
At the moment, am getting round this by pasting two sets of charts at
a time into Word. Painful, and results in a gap between the sets of
two which looks odd.
Any advice gratefully received.
Adrienne- Hide quoted text -
- Show quoted text -