Charts and Dashboards: Dynamic Chart Titles
11 December 2020
Welcome back to this week’s Charts and Dashboards blog series. This week, we show you how to create dynamic chart titles.
Everybody has done quarterly reports, we have to pump out the same charts again and again with different data. Say you have all of the charts dynamically linked to your data, but every quarter you have to go through each one and rename them.
Dynamic chart titles are the answer.
To create a dynamic chart title, we first need a chart and some data:
To make the chart title dynamic we link it to a cell. Before we do that, we have to designate a cell to hold the chart title.
The next step is to select the chart title and enter the cell reference into the formula bar, in this case it is:
='Dynamic Chart Title'!$G$18
Voila! We can change the title to anything we want and the chart will update automatically.
This may be time consuming at first, but you will soon speed up. Check out the file here.
That’s it for this week. Check back next week for more Charts and Dashboards tips.