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 -