Hi,

This explains the manual process of linking chart titles to a cell.
http://www.andypope.info/tips/tip001.htm

See the Source Data... dialog, right click chart for option, for
specifying a cell for the series name and or the category axis labels

For data label text from a cell try either of these free addins

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com


Cheers
Andy

Henning wrote:
Is it possible to add titles and katagory names to a chart from a cell in
the spreadsheet.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info