link to a chart in cell's comments

[schnett]

Hi,
I would like to find a way to link charts onto a cell's comment. For example if i select cell C5, I want excel to come up with a "live" chart on the side in the cell's comment. Can that be done ?

[Andy Pope]

A comment can not hold a live copy of the chart but it can hold an image.

Here is a reply I posted in the MS newsgroups.

You would need to run code every time the chart data changed.
So here is some code to place the image in a comment. Just change the chartobject and cell reference.

Please Login or Register  to view this content.