How to create dependent on a volume chart title
![Changeable title Excel for Microsoft 365 Changeable Title Chart Excel 365](/images/tips/346_365/1.png)
In the first example (see above), in the chart title, you will see the results of each team which will be modified according to the results.
In the second example, in the chart title, you will see the competition leader according to the dynamically updated data:
![Changeable title Excel for Microsoft 365 Changeable Title Chart Excel 365](/images/tips/346_365/6.png)
To create a chart with a title like the one above, do the following:
1. Create a chart (for example, see Creating a simple competition chart).
2. In any cell on the spreadsheet, create the data that you want to see on the title of your chart.
For the first example:
![Data for chart title in Excel for Microsoft 365 Data for chart title in Excel 365](/images/tips/346_365/2.png)
For the second example:
![Data for chart title in Excel for Microsoft 365 Data for chart title in Excel 365](/images/tips/346_365/3.png)
3. Add a title in the chart if needed by doing one of the following:
- On the Chart Design tab, in the Chart Layouts group, click the Add Chart Element button:
From the Add Chart Element dropdown list, choose the Chart Title, then select the place for the title:
- Click on the Chart Elements button, select the Chart Title list, then select the position of the title:
4. Select the chart title:
![Chart Title in Excel for Microsoft 365 Chart Title in Excel 365](/images/tips/346_365/4.png)
See how to select chart elements for more details.
5. Click on the Formula bar, enter the symbol = (equal), and choose the cell with data for the title.
For example:
![Enter Data Label in Excel for Microsoft 365 Enter Data Label in Excel 365](/images/tips/346_365/5.png)
Make any other adjustments to get the look you desire.
See also how to create 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.