If you don't want to get lost in all the charts in your Excel worksheet, then spend some minutes to read this article and learn how to add a chart title in Excel 2013 and have it dynamically updated. I'll also show you how to add descriptive titles to the axes or remove a chart or axis title from a chart. There's nothing to it! :)
You have to work a lot in Excel, make thousands of calculations and organize your data using different tables and charts. Your mind starts spinning when you see these yards of facts and figures. No doubt that graphical data are much easier to understand.
The problem is that when you create a basic chart in Excel 2013/2010, a title is not added to it by default. You have to add it manually. If you have just one chart in the worksheet you don't have to pay attention to the absence of the title. But your chart will look by far more attractive with it. Once several diagrams appear in your worksheet you may tie yourself up in a knot.
Here's a very simple example how to insert a chart title in Excel 2013. This technique works in any Excel version for all chart types.
In Excel 2013 the CHART TOOLS include 2 tabs: DESIGN and FORMAT.
You can place the title above the graphical image (it will resize the chart a little bit) or you can choose the Centered Overlay option and place the title right up on the chart and it will not resize it.
Now it is clear what the chart shows, isn't it?
You'll see the following sidebar to the right of the worksheet.
In Excel 2010 you'll find 'More Title Options' at the bottom of the Chart Title drop-down menu in the Labels group on the Layout tab.
Another way to display the Format Chart Title sidebar is just to right-click on the title box and choose 'Format Chart Title' as on the screenshot below.
Now you can add a border, fill color or apply 3-D format to the title or change its alignment.
Now you can change the font style, size or color of the title; add different effects to the text; modify character spacing.
The time has come for automating the chart title. The solution is quite simple - you need to link the chart title to a cell with a formula.
After you do that, you'll see the formula reference including the worksheet name and the cell address in the Formula bar.
It is very important to type the equal sign (=). If you forget to do it, you will just move to another cell instead of creating the dynamic Excel link.
So now if I change the text in cell B2, the chart title will be automatically updated.
A chart has at least 2 axes: the horizontal x-axis (category axis) and the vertical y-axis. 3-D charts also have a depth (series) axis. When the values don't speak for themselves you should include axis titles to clarify what your chart displays.
In Excel 2010 you have to go to the Labels group on the Layout tab and click the Axis Title button.
If you want to format the axis title, click in the title box, highlight the text that you want to format and go through the same steps as for formatting a chart title. But in the Add Chart Element drop-down menu go to Axis Title -> More Axis Title Options and make the changes you want.
Choose one of the solutions below that works best for you to remove a chart or axis title from a chart.
In Excel 2010 you'll find this option if you click on the Chart Title button in the Labels group on the Layout tab.
To clear off the title in no time, click on the chart title or an axis title and press the Delete button.
You can also right-click on the chart or axis title and choose 'Delete' from the context menu.
If you've just typed in a new title and changed your mind, you can click 'Undo' on the Quick Access Toolbar or press CTRL+Z.
Now you know how to add, format, automate and remove such small but important details as chart and axis titles. Don't forget to use this technique if you want to make a complete and accurate presentation of your work using Excel charts. It's easy and it works!
20 responses to "How to add titles to Excel charts"
Its very useful . Thanks a lot
If you want to remove chart labels, where do you find the options to do so within the Design tab (Chart Tools)?
How do I add a bottom chart title?
I see that I can use the ''add chart element'' from the tab. The thing is I like to have that option at the top right of my chart (as a plus sign). Though, when I click on my chart, the ''plus sign as much as the 2 other usual options do not appear. It is probobly an easy option to check but I can't figure it out. thank you
Thanks for sharing
I'm trying to put the chart title below a pie chart. The title format doesn't allow for this option. When I attempt to move the pie chart further up in it's frame to allow for the insertion of a text box, it only separates the pie slices but does not move. I also can't seem to lock the size of the pie chart so that I can increase the frame size and insert a text box below.
Very very very helpful, thank you for sharing!!
When I try to do a dynamic title per your example, entering "=A4" in the formual bar (where cell A4 has the text for the title), I get "You can only use external references to worksheets as references in a series formula" (Office 365).
Thanks for sharing!!
Simple, but extremely useful.
This just saved me a load of time, THANKS!!! Thumbs up all the way from Namibia :-)
Trying to add dynamic title to chart using = $A$1&" Length of Stay" but it doesn't seem to work in Excel 16?
Thanks for sharing.
Thanksforsharing
Thanks for sharing
Very useful stuff here - thanks for this!
i need help now please
how can i reference the link and type as well
Thank you
Thank You, this was helpful
Great suggestion for automating the chart title