Links in Graph Headings

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Does anyone know how to enter a link to a spreadsheet cell as part of
a heading in a graph such that the heading becomes the contents of the
linked cell.

Many thanks
Keith.
 
Hi Keith,

Select the charttitle and enter the sheet and cell reference in the
formula bar.
Does anyone know how to enter a link to a spreadsheet cell as part of
a heading in a graph such that the heading becomes the contents of the
linked cell.

Many thanks
Keith.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Even easier: select the text element (chart title, axis title, data
label), type =, and select the cell with the mouse.

- Jon
 
Back
Top