How to create dependent on a volume chart title

For some presentations will be interesting to add title that contains changeable data, for example, dependent on volume.
Changeable Title Chart Excel 2016

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

Changeable Title Chart Excel 2016

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

Changeable Title Chart Excel 2016

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:

Data for chart title in Excel 2016


Data for chart title in Excel 2016

    3.    Add title in you chart and select it:

Select title in Excel 2016

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

Enter Data Label in Excel 2016

Many thanks megaicons.net for funny icons.

Make any other adjustments to get the look you desire, see also Creating a chart with dynamic labels.