Excel 2007 - incorrect chart pasting into Word

[wildpark]

Hi all,

I've got a complex workbook with lots of linked data - on one sheet there are 8 fan charts showing financial data.

When I paste the charts as pictures into Word 2007 , everything is fine. This is all on XP.

However, when I try to paste special them as linked Excel Chart objects, 4 of the charts paste in okay, but the others don't - with the ones that don't, it's _another_ chart from that worksheet that gets pasted instead.

I've never seen Excel do this -any ideas why it might be doing so?

Thanks in advance,

John

 

[wildpark]

And sometimes the act of writing out a problem leads you to the solution! Recorded here in case it's useful to someone else.

The person who created the charts had copied and pasted them within the worksheet, adding data series to the later charts. However, this meant that several of them had the same name.

Pasting them into Word was fine, but pasting them as linked charts meant that Excel returned the same chart (effectively CH 004a) whether it was CH 004b or CH 004c that was being called from Word.

Renaming the charts (Layout tab / properties) to give them all unique names solved the issue.

 

[GlennUK]

Thanks for the update. I was watching this one with interest.