How to create dependent on a volume chart title

Excel 2016
If you need an informative and memorable chart, it might be useful to add a chart title that contains the data that changes, for example, depending on volume:
Changeable Title Chart Excel 365

In the first example (see above), in the chart title, you will see the results of each team which will be modified according to the results.

In the second example, in the chart title, you will see the competition leader according to the dynamically updated data:

Changeable Title Chart Excel 365

To create a chart with a title like the one above, do the following:

   1.   Create a chart (for example, see Creating a simple competition chart).

   2.   In any cell on the spreadsheet, create the data that you want to see on the title of your chart.

For the first example:

Data for chart title in Excel 365

For the second example:

Data for chart title in Excel 365

   3.   Add a title in the chart if needed by doing one of the following:

  • On the Chart Design tab, in the Chart Layouts group, click the Add Chart Element button:
    Add Chart Element button in Excel 365

    From the Add Chart Element dropdown list, choose the Chart Title, then select the place for the title:

    Add Chart Element - Chart Title in Excel 365
  • Click on the Chart Elements button, select the Chart Title list, then select the position of the title:
    Chart elements - Chart Title in Excel 365

   4.   Select the chart title:

Chart Title in Excel 365

See how to select chart elements for more details.

   5.   Click on the Formula bar, enter the symbol = (equal), and choose the cell with data for the title.

For example:

Enter Data Label in Excel 365

Make any other adjustments to get the look you desire.

See also how to create 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.