Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you didn't add a title to a chart at the time you created it, you can use the title options available on the Layout tab in the Ribbon. As a reminder, when you do create a chart and particularly if you've done it using one of the quick methods-- for example, this chart was created with a keystroke shortcut Alt+F-- The chart has most of the features needed; it certainly does not have, however, a chart title. On the Layout tab we can make a choice called Chart Title. If you go to the Design tab and use Chart Layouts, possibly you might want to take care of other titles as well at the same time, and legends as well.
Ironically, those choices called Chart Layout are on the Design tab. The Layout tab itself has the choice Chart Title. A quick look at these. Two choices, the description of them is fairly obvious. Above the Chart, I think this is what a lot of people would want. The other choice here under Chart Title, Centered Overly Title. It does not resize the chart. The title will look there. This is plenty of white space in the chart, so that would be viable option here. Maybe we'll just leave it this way. Now we don't have to actually select this or drag across, but that you can do that.
I'm sure your chart titles will not contain those two words most of the time. So that's not really necessary. So as soon as we see Chart Title, what we could do is simply start typing. In other words, when we first created it, we see this. I'm simply going to type in a description of the chart, namely 'Sales - 2011'. Enter. As I'm typing this, you see this in the formula bars. As soon as I press Enter, of course it finds its place on the title. A minor point here, but occasionally useful. Sometimes we want more information in this title.
I'm clicking the formula bar now, and I could've done this earlier before pressing Enter, but I would like to have on the line below this, 'preliminary' or 'projected' or something like that. So after the 2011, I'm going to press Alt+Enter. Some of you may know that's the way to do a line break, and now I'm going to type in parentheses 'Projected' and then Enter and we see what happens this way. So you can make some changes and have multiple line entries this way as well. Now suppose this is the title, you've used it a while, you want to make a change to it, or you want something completely different.
If we simply clicked near the title, or I don't have to be right on it, the box is highlighted. We could click in the formula bar and type something completely different or alter this if we want to. Maybe I'll put in 'Sales-2011 Final' this time on the same line. So without really editing what's there, I'll just type this and press Enter and we see the title there. If we want to change the location of it, Chart Title is centered above chart this way. We simply have adjusted it that way as well too. You can also do formatting on it also.
A recommended approach there might be simply right-click on the border and then go to Format Chart Title and explore some of those options with regard to filling in the color. Not necessary, but for some people you might want to pursue that as well, too. So it's easy to put in a title or to make a change to it or to replace it, adding a title or adjusting any existing title, to simply use the title options available on the Chart Title option in the Layout tab in the Ribbon.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 97595 Viewers
80 Video lessons · 141082 Viewers
59 Video lessons · 59430 Viewers
52 Video lessons · 72750 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.