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