Dynamic chart title from the cell

In this Excel tutorial you will teach yourself how to insert dynamic chart title from the cell.

First prepare some data table.

data table

Create a chart without a title. If you created one just click on the title and delete it.

Example chart without title

Go to the ribbon to the Design tab which just appeared. Click Add Chart Element button. From the list choose Chart Title and select Above Chart or Centered Overlay.

ribbon chart title above chart

In the formula bar type = and click the cell which contains the title for your chart.

Chart title from cell

For me it is =Sheet1!$A$1. Sheet1 is the name of my worksheet and A1 is the cell which contains the chart title.

Dynamic chart title from cell ready