Sorry I did not complete my post yesterday. Here it is. I know we can create a text area in a chart sheet and insert a cell address of another worksheet into it (say sheet2 cell A4). Can we do the reverse - insert the address of the chart text area (if it has a cell address) into another worksheet's cell address (say sheet 1 cell C7) so that when I make any changes to the text area in the chart it will update sheet 1 cell C7? Thanks.