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 ?
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 ?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks