COPYing the content of a cell to a graph as Title

G

Guillermo

I need to copy the content of a Sheet1 cell (just a name
to a graph (in the same xls file) as its title.
Ctrl+C does not retain the info as I go back to the graph
sheet to PASTE it on the title.
When I write a macro, the code displays an error that
says the procedure can't be performed.
Help, please. Thanks.
Guillermo.
 
T

tjtjjtjt

Click on the Current title of the chart. In the formula bar type
Once you have the = in the formula bar, switch to the sheet that contains the cell you want to link to, then press enter
If you don't currently have a title, enter it by going to Chart|Chart Options. Make sure you are on the Chart Title tab

t

----- Guillermo wrote: ----

I need to copy the content of a Sheet1 cell (just a name
to a graph (in the same xls file) as its title
Ctrl+C does not retain the info as I go back to the graph
sheet to PASTE it on the title
When I write a macro, the code displays an error that
says the procedure can't be performed
Help, please. Thanks
Guillermo
 
Top