Hi,

1. you can't break the chart apart in Excel but you could do a screen shot,
and crop to the legend and put it into Word.
2. You can resize the legend to be multiple rows and multiple columns say
10x7 if that would help. You can resize the Font of the legend to make it
smaller.
3. Using Ed's suggestion you can turn off the legend in one chart and in the
second chart you can resize the legend to take up the entire chart, covering
the plot. If necessary you can change the legend fill so you can't see the
chart.

if any of this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Michael" wrote:

Thanks Ed but when I am deleting the legend from one, the chart is not
resizing itself - it was extra long as the legend was beneath with about 70
odd legend references. This is resulting in a large white space beneath the
chart and resizing it manually also changes the chart.

I am reluctant to start again as I had to manually add each series data
individually to ensure correct labelling and capture. I originally tried to
do in bulk but it kept failing.

"Ed Ferrero" wrote:

Hi Michael,

This might not be very elegant, but why not copy the chart so you have two
charts, then delete the legend from one and minimize the plot area of the
other whilst maximising the legend?

Ed Ferrero
www.edferrer.com