How to create dependent on a volume chart title

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

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 Chart Excel 2016

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

   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

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.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.