Thread: Excel Charts with attached comments option

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/comm...excel.charting

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
_______

"Neils" <Neils@discussions.microsoft.com> wrote in message
news:60FC0A08-7834-4967-976D-E8AF84A0CAF0@microsoft.com...
> 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.
>

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?


"Neils" wrote:

> 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/comm...excel.charting

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
_______

"tom zane" <tomzane@discussions.microsoft.com> wrote in message
news:3C9CB0D6-D945-489A-BD39-1DCDEE377B16@microsoft.com...
>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?
>
>
> "Neils" wrote:
>
>> 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/comm...excel.charting