Excel Help! How do I...

[TheLemming]

Hopefully someone out there will have an answer to this one.

I want to add a linked picture of cells to a chart, however whenever I paste this into a chart, it seems to lose it's cell link and instead paste as a straight picture.

Any ideas out there guys and gals?

[m-five]

Is it a static picture you want to add or a live data one?

[TheLemming]

Live data, unfortunately when putting into a worksheet tab that is a chart it ceases to be live data and instead reverts to a normal picture.

[m-five]

All I can think of doing is either add a table to the bottom of the chart (if that's what you need to do), or to make the chart part of another worksheet that you can then format to look like a chart with you data around it.