Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
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.
There are currently no FAQs about Excel 2007: Charts in Depth.
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.