COPYing the content of a cell to a graph as Title

  • Thread starter Thread starter Guillermo
  • Start date Start date
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.
 
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
 
Back
Top