Text Linked to Series Point (2000 SR1)

Topic

New Reply

Is there a way to link a text box to a series point in an Excel Chart? If I add a text box and add new data all of the text boxes with comments have to be rearranged and there are several data points in each chart.

Reply | Quote

Replies

I’m working in 97 SR2, so 2000 might have fixed this but…

I don’t know about linking a text box to a point, but you can modify the data labels for a series. It is a bit laborious as you have to change all of them.

What you do is right click on the particular series, and select Format Data Series.
Click on the Data Labels tab, and click on Show label.

This will show the x-axis value for each point next to it. You can then click on a point, pause and then click again (ie two left clicks as opposed to a double-click). This will let you edit each data label. The formatting is non-existent and you have no control over the line wrapping, but it is linked to the data point.

HTH

Jon

Reply | Quote

This works great. THANKS!!!

Reply | Quote

There is always the possibility to make your own data labeler add-in. You can find some free downloads on the web e.g. Baarns’ website

Reply | Quote