How can I add a footnote or comment to a data point in a chart?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create one's own text for a specific data point in a line
chart? (e.g. a word or two that is not in the data table) I can add a note
below the chart in a worksheet, but would like something that would stay with
the chart itself.
 
Select the series (one click) then select the point (another click). Format
menu > Format Selected Point > Data Label. Add a data label to the point
using any of the options. Select the data label (two single clicks), then
edit the text or type your new text in the formula bar. Bonus: to link the
data label to a cell, select the data label, type = in the formula bar, then
select the cell.

There are utilities that can do this for you, which is especially helpful if
you have lots of labels to add:

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

- Jon
 
Thank you! Seems I was clicking too fast on the label, doing a "double
click"- the key for me was your "two single clicks". Gotta slow down...
Thanks for your quick and helpful reply!
 
Back
Top