Before Excel 2007, you could create a picture on a separate chart sheet but
linked to a table. This was done by using Sh Edit and then Paste As Picure.
Once the picture of the table values was pasted on the separate chart sheet,
you could select it, click in the formula bar and type a link.

I have tried doing this in Excel 2007, but so far no success. The new
options such as Paste As Picture do not allow links, and the option Paste
Picture As Link only works on the same sheet, but not on a separate chart
sheet. Is there a way that I haven't discovered yet?

Thanks if there is!

Apparently this capability has been removed from Excel 2007. Pity.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gerry Verschuuren" wrote in
message ...
Before Excel 2007, you could create a picture on a separate chart sheet
but
linked to a table. This was done by using Sh Edit and then Paste As
Picure.
Once the picture of the table values was pasted on the separate chart
sheet,
you could select it, click in the formula bar and type a link.

I have tried doing this in Excel 2007, but so far no success. The new
options such as Paste As Picture do not allow links, and the option Paste
Picture As Link only works on the same sheet, but not on a separate chart
sheet. Is there a way that I haven't discovered yet?

Thanks if there is!