ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I add a comment to a data point in a chart? (https://www.excelbanter.com/charts-charting-excel/94009-how-do-i-add-comment-data-point-chart.html)

erin_taylor

How do I add a comment to a data point in a chart?
 
I am needing to add a comment to a specific data point in a chart. For
instance, now when I scroll over a data point the source, series, and value
pop up. I need to change the pop up box to explain the reason for a specific
value. Any suggestions?

Gklass

How do I add a comment to a data point in a chart?
 
erin_taylor wrote:



One way is to plot an extra data series with just one value -- the same
value as the original series; use the new series name as the data label.

or use the chart labeller in the J-walk chart tools add in:
http://j-walk.com/ss/excel/files/charttools.htm
(but this doesn't affect the pop labels)


I am needing to add a comment to a specific data point in a chart. For
instance, now when I scroll over a data point the source, series, and value
pop up. I need to change the pop up box to explain the reason for a specific
value. Any suggestions?


Andy Pope

How do I add a comment to a data point in a chart?
 
Hi,

Tushar Mehta has a free add-in.
http://tushar-mehta.com/excel/softwa...bel/index.html

Cheers
Andy

erin_taylor wrote:
I am needing to add a comment to a specific data point in a chart. For
instance, now when I scroll over a data point the source, series, and value
pop up. I need to change the pop up box to explain the reason for a specific
value. Any suggestions?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 10:53 PM.

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