How to create dependent on a volume chart title
![Changeable title Excel 2016 Changeable Title Chart Excel 2016](/images/tips/346_2016/1.png)
In the first example, in the title of the chart you will see the results of every team that will be changed by results:
![Changeable title Excel 2016 Changeable Title Chart Excel 2016](/images/tips/346_2016/2.png)
In the second example, in the title of the chart you will see the leader of the competition:
![Changeable title Excel 2016 Changeable Title Chart Excel 2016](/images/tips/346_2016/3.png)
To create the chart with title like this one, do the following:
1. Create a chart (for example see Creating a simple competition chart).
2. In any cell, create the data that you want to see on the title of your chart. For these examples:
![Data for chart title in Excel 2016 Data for chart title in Excel 2016](/images/tips/346_2016/4.png)
![Data for chart title in Excel 2016 Data for chart title in Excel 2016](/images/tips/346_2016/5.png)
3. Add title in you chart and select it:
![Select title in Excel 2016 Select title in Excel 2016](/images/tips/346_2016/6.png)
4. Click on the Formula bar, enter the symbol = and choose the cell with data for the title:
![Enter Data Label in Excel 2016 Enter Data Label in Excel 2016](/images/tips/346_2016/7.png)
Make any other adjustments to get the look you desire, see also Creating a chart with dynamic labels.
See also this tip in French: Comment créer un titre de graphique dépendant de la valeur d'une cellule.