(I have more luck asking my Excel questions here than using Excel’s Help)
Let’s say I have a chart in Excel, and the chart has a legend at the bottom. I would like to copy that legend – just the little box that decodes the colors – and paste it as a picture in another document.
I can’t seem to do that, although I’m pretty sure I’ve done it before. If I click on the legend and Copy, it copies the entire chart.
I use Excel 2003, so my answer may not be up to date, but after noodling around with a chart that had a legend and not finding any way to copy it, I’m guessing that it can’t be done. I’m also guessing that the reason is that the content of the legend is created automatically and is simply a visual representation but without actual substance. In Excel 2003, it isn’t even possible to edit a legend, except to change the formatting. But if, for instance, you want to change the words in the legend, you would have to change them in the underlying data, not in the chart. I hope this helps.