Copy text in a cell into a text field in a graph?

[Cubicle53]

Hi,

Is there a way to automatically copy text in a cell (say A4 = "File Name: Test 23 (July 16, 2007).txt") into a text field in a graph?

I have a spreadsheet with multiple graphs.

I dump numbers into the spreadsheet and it automatically adjusts the graphs.

I can't figure out a way to create titles in the graphs that are unique to the data.

Right now I have to copy and paste the text from the spreadsheet into each graph - 25 graphs in total.

Any suggestions?

Thanks.

 

[Gerald Higgins]

Click on the chart title, then type the cell reference into the edit box at the top of the screen, for example

=$a$1

 

[The Todal]

Put an Autoshape on the graph. Select the Autoshape and then enter "=A4" on the formula bar.