How to create dependent on a volume chart title

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

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:

Changeable Title Chart Excel 365

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 365
Data for chart title in Excel 365

   3.   Add title in you chart and select it:

Select title in Excel 365

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

Enter Data Label in Excel 365

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.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more