Why can't I link text to autoshapes

  • Thread starter Thread starter Caritimo
  • Start date Start date
C

Caritimo

OK - I've searched this group and found numerous references to this
issues:
I know - select the autoshape, type = in the formula bar then click on
the cell you want to link the autoshape to. Press Enter and voilà the
text appears in the autoshape.
Only problem, it doesn't work for me.
Every time I follow those steps, I get a new plain text box, but not
the text in the autoshape I started with.

Give me a hand, it's been driving me crazy for days!

T.
 
As answered in .excel.misc --

'===================================
I'm not sure how John did it, but you could:

Select the chart
Click in the Formula bar, and type an equal sign
Click on the cell you want to link
Press the Enter key (a text box will appear in the centre of the chart)
With the Textbox still selected, on the Drawing toolbar,
click the Draw button
Choose Change AutoShape, and select a shape
On the Drawing toolbar, select a line and fill colour
Resize the Autoshape to fit the text
'=====================================
 
Back
Top