Excel 2010 linked chart not showing up...Bug?

[bearwise]

I have 3 excel workbooks. I am attempting to link a chart from workbook1 to workbook2 by the paste special method. Workbook2 already has a linked chart in it from workbook3 and works perfectly fine. But when I link a new chart from workbook1 to workbook2 only a blank object appears. The object has the address of the correct chart but the linked chart is not visible. Anyone know a fix?

 

[kpark91]

Instead of linking charts, why don't you just use the original data points?

 

[bearwise]

That is what I'm trying to avoid. I need to have up to 8 linked charts on this one sheet.