View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
GeneW GeneW is offline
external usenet poster
 
Posts: 6
Default How do I (or can I) add a chart within a comment?

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.