adding chart title from cell

You can do it like the following .

=Sheet1!$D$2

select the chart title and type the required formula in the formula bar

Ram P

You have to add a title to the chart first (with any word); right click the chart, select Chart Options > Titles > Title - type any word, then click OK). Then click on that title that appears. When you type in the formula bar (not on the chart title), be sure to add the = sign and sheet name.