software

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
quot;commented onquot; cell(s)? If so, how can you do it?

I would like to be able to see comments when I mouse-over a data point on a
chart if the data point was taken from a cell with a comment.

This isn't a native Excel capability, but it's an interesting idea, and one
that could be accomplished using VBA.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______
quot;Mike P. from KCquot; lt;Mike P. from gt; wrote in
message ...
gt; Is it possible to have a data cell's comment (which shows up on mouse-over
gt; of
gt; the red triangle in the upper right of the cell) also show up on
gt; mouse-over
gt; of the data point on a chart that takes a data point or points from a
gt; quot;commented onquot; cell(s)? If so, how can you do it?
gt;
gt; I would like to be able to see comments when I mouse-over a data point on
gt; a
gt; chart if the data point was taken from a cell with a comment.