Your directions for embedding a chart to a comment was great.
Do you have any thoughts on how I can have a real-time chart open and close
so it would be attached to a cell?
I am flexible on was to do this, but I have an excel spreadsheet and I want
peoples sales numbers to be on the sheet but not always open large pictures.
I would like them to work very similar to the way comments pop up.
Also, would you know how I could go about making this suggestion to
Microsoft if there is not a way for this to work?
Thanks in advance for your help.
"Andy Pope" wrote:
Hi,
You can export the chart as an image and then set the comments picture to
that image.
http://www.contextures.com/xlcomments02.html#Picture
Obviously the chart will not update in real time.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"GeneW" wrote in message
...
I want my chart (very small chart) to emerge when you hover over a sales
number.
As if the chart was embeded within a comment.
When you go over a cell with a comment, it opens up.
I do not want the chart or graph to be present on other pages or tabs.