ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel Charts with attached comments option (https://www.excelbanter.com/charts-charting-excel/76850-excel-charts-attached-comments-option.html)

Neils

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

Jon Peltier

Excel Charts with attached comments option
 
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" wrote in message
...
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.




tom zane

Excel Charts with attached comments option
 
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


Jon Peltier

Excel Charts with attached comments option
 
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" wrote in message
...
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





All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com