I managed to work around an unusual Excel bug today, and pass along this tip in case you get in the same situation.

If you create a dynamic text box on a chart (a text box which contains content looked up in a worksheet cell, Excel sometimes locks it up and prevents you from selecting, editing, or deleting it.

When I created another text box and selected it, I could then access its name in the name box which is to the left of the formula bar. By backspacing over the new text box number and typing the old text box number, I was able to select the locked-up box and work with it.

The original text box locks up again when you delete the new one, but you can create another new one and use it to get into the name box should you need to do it again.

--Matt Mitchell