This question was also asked in 2006, but the answer was quite a bit of a
workaround and I am hoping someone might have worked it out by now, I have
Excel 2003.

Basically I have a chart with a large amount of data that I need to present
in a report. I want to show the chart and the legend, but as the legend is so
large it skews the image. Is there anyway to seperate these (without doing a
cut and paste job in paint), so that I can place them in a word document?
Would like to keep it somehow all linked.

Hope this makes sense, thanks Michael