By way of background, there are multiple charts on a page, with a
separate header which is a picture. The charts have no borders and
'float' on a grid which is the same colour as the chart area. The grid
has borders round groups of 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 the picture header - 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.

In Excel 2003 I've used copy as picture with no issues at all - all
copies over to Word perfectly. In 2007 most 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 header copy over fine.

I've tried all the combinations of Copy as Picture / 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