View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Comments in Charts

It remains an interesting idea. I've had no further interest in it until
now.

I haven't addressed this problem yet, because it's a multiple-part routine.
It requires chart events to detect a mouseover on the chart, it requires
parsing of the chart data to determine which cell contains the data point's
value, and it requires reading and displaying of the comment.

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


"Fred Zack" wrote in message
...
Two years ago Mike P. from KC asked:
"Is it possible to have a data cell's comment (which shows up on
mouse-over
of
the red triangle in the upper right of the cell) also show up on
mouse-over
of the data point on a chart that takes a data point or points from a
"commented on" cell(s)? If so, how can you do it? "

The only reply was from Jon Peltier: "This isn't a native Excel
capability,
but it's an interesting idea, and one that could be accomplished using
VBA."

Does anyone know if this has been done yet? If so how could I get that
macro?