Dynamic chart title, link chart title with a value from the cell

Today, we are going to make a sim­ple trick, i.e. link­ing the Chart Title with a val­ue from a cell. It will make the Chart Title a bit more dynam­ic. The task is sim­ple. We have to select the chart, so that it has sol­id bor­ders. We go to the Chart Title edit mode. As we can see, the Chart Title bor­ders change into a dot­ted line, which we don’t want. We have to click some­thing else on the chart, then click again on the chart title one time, so that the bor­ders stay sol­id (Fig. 1).

Now, we have to click the equal sign, which will appear in the for­mu­la bar (Fig. 2).

We are start­ing to write a for­mu­la for the Chart Title. We are click­ing cell A1 because we want to have ref­er­ence to this cell. Then, we are press­ing Enter to link the Chart Title to this cell (Fig. 3). 

When we change a val­ue in the cell, the Chart Title also changes (Fig. 4).

This sim­ple trick works also with Axis title. We have to select the Axis title (Fig. 5). 

Then, write the equal sign and select a prop­er cell. In our case it’s A10. After enter­ing it, the Axis title changes (Fig. 6). 

We can do the same with the bot­tom Axis title (Fig. 7). 

That’s how you con­nect the Chart title and Axis titles to val­ues from cells.