how do I link a text box on a chart to a specific data point?

[JFQuestion]

I have a text box in a chart that I want to move with the data, as additional
data is added to the chart. For instance, if the datapoint is January 5,
2008, as I add additional days, I want the text box associated with the
January 5, 2008 datapoint to move with the graph.

 

[ShaneDevenshire]

Hi,

Text boxes don't track with the data. Replace the text box with a Data
Label. Select a single point in a series that is near the location of the
text box. Choose Format, Selected Data Point, on the Data Labels tab turn on
Value. Click OK. Select the data label and type the text that was in the
Text box.

You can link the data label to any cell in the spreadsheet and enter your
comment in the cell instead. You do this by single clicking the border of
the data label and typing =A1 or whatever cell address you want. Note, you
are not typing into the data label, but on the formula bar.

If this helps, please click the yes button.