Am learning charts and looked into charts in UserForms too, and couldn't find any way other than copied picture of a chart GIF/JPG.
So Excel 2007 seems stuck with embedded charts in a worksheet. Am doing numerous charts on a sheet. At least I am able to move the charts around almost like a UserForm using click, drag, drop on screen.
But I have not been able to find an easy way to view live data in one screen, while viewing on an 2nd monitor the charts linked to that data.
Seems to take two workbooks using Menu - "View, Arrange All, Tiled" to see both workbooks running at same time linked to same instance of Excel. But that is only if Windows has set both monitors together as non-extended mode. Can't figure any other way to link the two easily while seeing them on separate monitors.