Excel Charts with attached comments option

[Guest]

It would be good if you could add a comment to a cell and have an option when
charting that cell to either show the comment or not. The comment should then
be linked to that specific data point.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...af84a0caf0&dg=microsoft.public.excel.charting

 

[Jon Peltier]

You can do this already, not using Excel's built in functionality directly,
but making use of its flexibility. And actually, the programming is already
done. Try one of these two fine (and free) Excel addins:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

 

[Guest]

I have tried the XY chart labeler and the comment does not stay locked to the
particular data point if the source data changes. Is there someway to lock it?

 

[Jon Peltier]

Tom -

The label will stay locked to the point, but only if you use one of the
default positions (Left, Above, etc.), and then don't adjust the position.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______