Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
You can add vertical and horizontal titles, located on the left and bottom sides of a chart, by using the multiple options available from the Axis Title button on the Layout tab in the Ribbon. So in this particular chart let's imagine we have not yet done the main chart title. Let's say we tackle the titles down the left-hand side and across the bottom. Now neither one of these is a requirement, but in many, many cases--particularly the vertical axis on the left side--we definitely want to have that here to explain what these numbers mean.
It's not to say that you couldn't put it in the main title, but typically it goes along the left-hand side. Look at the options that we have here under Axis Titles. This is in the Labels group. It's on the Layout tab of the Ribbon. Primary Horizontal, in this case Primary Vertical Axis Title. Rotated Title, probably the most common choice. As soon as I click this, you'll see what we're about to do. Let me show you the other options before completing this entry. Back to Axis Titles. Less likely here is the choice Vertical Title, although if the words are short, that would make sense in some situations.
Typically, this is harder to read, and the third choice here might be Horizontal Title. This eats up a lot of chart space, but there, too, that might be appropriate for certain kinds of short titles. In the example here I want to indicate that these numbers represent millions of dollars just the way we see it over there in row 2 above the data. So Axis Titles here > Primary Vertical Axis Title > Rotated Title, and we see it that way. I simply want to say 'Sales-Millions' of Dollars, but if I'm going to put sales maybe in the main title or below the data, maybe I'll just say 'Millions of Dollars'.
As soon as press Enter, we see the information there. If you want to change the size of that font, by the way, you can go to the Home tab here, and if it's size 10, for example, just slide over this, and you can say it growing as I slide over these, without even making a click just yet. So we can certainly adjust the size of that quickly, easily if you wish. Now sometimes you do one information below. Maybe we're going to put a main title up above that possibly names the company or the year, and sometimes it's just a tossup of what works better for you.
In many, many charts you will not see a title below the data, but why not? In the example here, once again, if we go to the Layout tab > Axis Title, this time Primary Horizontal Axis Title, fewer choices here. Title Below Axis or None. Well, we do want a title let's say right here. Maybe we want to put something in about the company name or indicate that maybe this represents three regions, or three different parts of the world, whatever it is that seems appropriate for us. Maybe I'll just put in the example here '2011 - Total Sales'.
Enter, and we see the information here. At a later time if we come back and decide to either get rid of this, of course we can just click on that and press Delete like that. I'm going to press Ctrl+Z to undo that. At other times maybe we simply want to change the wording, and many times it's going to be faster, rather than trying to edit this--but you certainly can. For example, I can click down here and type in the word Volume right in front of Sales, something like that maybe. That's appropriate. Or if not, another way if I want to retype all of this, simply come here, click on it, and jump into the formula bar and start typing something.
Actually, you don't even have to go into the formula bar. You can just start retyping. So maybe I want to reverse the order of this. I just want to say 'Sales 2011', Enter, and we see how that works. So, quite a few different ways to adjust titles. They are important here and there, the horizontal and vertical titles on the chart. You can add them, remove them, or alter them either by the typing method you just saw or primarily through the Layout tab, the choice called Axis Titles.
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.