Links in Graph Headings

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

 

[Andy Pope]

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.

--

Cheers
Andy

http://www.andypope.info

 

[Jon Peltier]

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

- Jon