Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Adding titles to charts can be a little tedious and even time consuming if you insist on typing them. However, you can pick up data from existing cells and put them in the chart titles. If you've created a chart, for example this one, and you don't have that kind of information, strong suggestion here is after having clicked on the Chart and activating the new Chart Tools Ribbon, on the Design tab the Chart Layouts feature, right here. Now, depending upon the chart type you'll see more or fewer entries here and if you haven't worked with these a whole lot, do take advantage of them.
Because they give you some built-in styles, and you will notice on some of them a gray bar on the top. That's space for a main title. Sometimes you'll see them down the left-hand side, sometimes on the bottom. So, we might pick one of these here, for example this one, and suppose we want to put in a title here, but why don't we use the data that's actually right here. This is actually in cell B1. In a chart, once you've chosen one of the Chart Layouts, click for example here under Axis Title. Then click in the formula bar, type equal, and then click on the cell that's got the data you want and then press Enter, and there we see the title there.
Similarly over here, now this might be a long title, we might want to reconsider, but still, Axis Title. We don't want to do any typing here. Click in the Formula bar, type equal, then this time click on cell A2 and press Enter. There it is. You have the ability and the right to type in anything you want, but why not take advantage of the fact that many times on the chart, the title that you want is likely to be embedded already in the data and why not take advantage of it, like we're doing here? And if we change our mind about the content of the title, possibly we might even change this cell, and it will be reflected in the chart immediately.
Maybe we don't use the word Company here that often and everybody knows that we are anyway. So, we might just click in here, maybe double-click and get rid of the word Company. You might even change the font size here too. Make it bigger and so on. Now, that didn't have any impact on the font size over here, so I might click here and then go into the Font group on the Home tab and slide across some of your choices here and watch that title grow. But take advantage of the fact that you can create titles by associating them with cell addresses within your worksheet.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73596 Viewers
80 Video lessons · 129285 Viewers
52 Video lessons · 63658 Viewers
59 Video lessons · 49418 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.
Your file was successfully uploaded.