Let’s add the chart title.
Just select the Chart Title area and type the title of your chart.
Editing the Chart Title
Pro tip: We can make the Chart Title dynamic and linked to a specific cell.
In this case, every time we want to change or edit the chart title, the only thing we need to do is to update the related cell value.
To do that, select the Chart Title area and click inside the formula bar (the section where we usually enter a formula in the cell).
Type the following formula:
where “cellAddress” is the name of the cell with the chart title value (this is cell A3 in our example).
Just type the equal sign (“=”) and click on the cell with the chart title value.
Don’t be confused by the screenshot above – typically a cell address may include a Worksheet’s name where this cell is located.
So, the full cell address frequently looks like: ‘worksheetName!cellAddress
In addition, let’s add the additional text box inside the Chart Area that will show a text definition for the secondary Data Labels.
To do that, let’s select the Chart Area, then Go To:
INSERT tab on the Excel Ribbon > Text Section > Text Box
(alternatively: INSERT tab on the Excel Ribbon > Illustrations Section > Text Box)
Inserting the TextBox with the additional note
Once the TextBox has been inserted, let’s type “New Apps” and format it.
We don’t need it to be dynamic, as “New Apps” definition is common for all “New Apps” columns.
Pro tip: Because we activated the Chart Area before the TextBox was inserted, it’s linked to this Chart object, so we don’t need to group them.
They are locked together, and the TextBox will be moved or edited in parallel with the chart.
Otherwise, both objects would be existing separately from each other and if we were to move or edit the Chart object, the TextBox object would be kept untouched.