Text into charts (excel 2007)

[Guest]

Hi,

In Excel 2003 I was able to add links to cells and text into a chart be
simply selecting the chart, hitting"=" and selecting the cell or by simplay
typing the text into the chart. Has this functionality been disabled in 2007
as I can't seem to do this anymore? Does anyone have any suggestions?

thx

 

[Andy Pope]

Hi,

You will need to select the chart and then use the Insert > Text > Textbox,
to add the textbox manually.
Then use the formula bar to make the link by either typing in full or = and
selecting cell.

Cheers
Andy