How to Create a Chart with a Dynamic Title in Excel 2010

Say you created a chart that tells something about your data visually. But you want your chart title to change when your data changes or you want your title to be assigned from a cell. In this post, we will go through how to create a dynamic chart title in Excel 2010.

1. Select the range of cells that you want to use in your chart. Go to Insert / Line / Line Chart. This will automatically use your data and create a line chart.

2. Select your chart and go to Chart Tools / Layout / Chart Title / Above Chart to add a title to your chart.

3. First select your chart and then your title and go to 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. 

4. The output will look like the picture below.