How to create dependent on a volume chart title

In the first example (see above), in the title of the chart you will see the results of every team that will be changed by results.

In the second example, in the title of the chart you will see the leader of the competition:

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:

   3.   Add title in you chart and select it:

   4.   Click on the Formula bar, enter the symbol = and choose the cell with data for the title:

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.