Links in Graph Headings
 

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.

Links in Graph Headings
 

Hi Keith,

Select the charttitle and enter the sheet and cell reference in the
formula bar.

Keith wrote:

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

Links in Graph Headings
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:
Hi Keith,

Select the charttitle and enter the sheet and cell reference in the
formula bar.

Keith wrote:

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.