Excel world how to create a chart with a dynamic title in excel 2010 the formula bar and enter equal sign and address the cell that contains the title this will change the title to the value of the cell you pointed ccuart