How to create dependent on a volume chart title

In first example, in the title of the chart you will see the results of every team that will be changed by results:

In second example, in the title of the chart you will see the leader of 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 same 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.