It is eay to make an example to do this. You just nee to select the chart
title and then input an formula such as "=Sheet1!A1" in the formulabar.