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?