8. Formatting Chart Titles
Chart titles need to be written and formatted correctly so they are easy to read and understand. Learn how to create static and dynamic chart titles for your charts.
Formatting chart titles
- Add chart titles by clicking on the Layout tab and selecting Chart Title
- Chart titles should be aligned left and the font size should be reduced
- Always include the unit in your chart titles, especially if your axes don't have labels
Dynamic chart titles
1 Link a chart title to a cell on the Excel sheet
2 Use & to chain text strings to a cell value
3 Use the TEXT function so that the cell value is in the correct format within the title
CTRL + B: Bold text
F2: Jump back inside a formula
In PowerPoint, you have the freedom to add titles to charts manually using a text box and other features such as lines. You can also add text boxes and lines in Excel but in fact, it's much easier to just add a title within the chart object. To do so, select the chart, go to the Design tab in the ribbon and Chart Title. And I'll include a title above the chart. Then simply start typing your chart title. And then press Enter once you've finished.
When using titles in Excel, I'll normally reduce the font to something a lot smaller, say 12 and I'll move my heading to the left-hand side. I think this looks better than when the title is placed in the middle of the chart. So as you can see, titles for charts are pretty easy to create. I tried to make sure my titles are always in the same format. The first part of the title describes the contents of each bar, in this case, the Revenue by Region. And the second part normally not in bold is the unit. To remove the bold from the percentage sign I simply select it with the mouse and Ctrl + D. Sometimes particularly when modeling, you may want to change the title of a chart dynamically when the value of an input is changing. In this example, I have a chart showing a revenue projection for the next six years based on a growth rate of 10 percent. However when I change my growth rate to say 15 percent, the numbers change, but unfortunately our title does not. So how do we link our title to an input cell? We'll start by creating the ideal title within a cell itself and to do this I'm going to write a text string that will correspond to the title of the chart and include the growth rate input using the & sign. So I'll write = open inverted commas, then Revenue Projection for inverted commas. I'll then write & and include the growth rate figure.
I'll then write another & sign and continue the string that says Annual Growth rate. And of course, I'll include my units as well. I'll then close the inverted commas and press Enter. This version of the title when I update my growth rate also updates accordingly. But it's showing 0.1 instead of 10 percent. I'd like it to show 10 percent. To do this, I'll simply pass my B4 value into a text function. So I'll press F2 to jump back into the formula, I'll wrap a text function around B4 and the format of the text will be 0%.
I'll then close the bracket and press Enter. And now our title will change perfectly within this cell when I change my growth rate. All I need to do now is to link the title of my chart to this cell. So I'll select the title and then in the formula bar I'll simply write equals and select the cell which is B5. And now when I change my growth rate say to 8% and the title changes automatically. When you have the input to a model as the title for your chart, always consider a dynamic title, otherwise, when you change the input and replot the data on the chart, your title may be incorrect and lead to confusion for the reader.