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.
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.