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.
When you work with Excel charts you will need to become familiar with certain terms that you might not have seen or heard before. And although it's best not to memorize the various parts of a chart, knowing the names of what are called chart elements will increase the value, not only of this course, but any kind of instruction material related to Excel charts. In this particular worksheet there are a number of charts associated with the data, different ways to display the same data by way of a chart. To the right of the data, a green border chart. I'm going to click on it here, and as I slide the mouse around into this portion of it, you might see here and there words pop up, like Plot Area like we're seeing right now.
If I slide upward into the green area, we'll see Chart Area. On all charts we'll see these terms. I'm going to slide the mouse over the box right here. You see the word Legend. You've probably heard that before, and certainly you've see these on maps, a legend that explains what lines mean, what symbols mean. We get use to these terms. And not only where you see some familiar terms like Legend, here's a line here. What's the line? It's a gridline, and to be more precise, a Vertical Axis Major Gridline That suggests there might be Minor Gridline somewhere.
So on different charts here and there we'll see different kinds of chart elements. How about the bottom of the chart here? Let's slide into the bottom of the green chart. That's the Horizontal Axis. Well, sure enough, there's a Vertical Axis over on the left-hand side as well. And as I've said, don't memorize these, but the more you work with charts, the more you'll need to know what these are. Another term is going to come up, and it's a little bit illusive at first but you'll become very familiar with it-- as I click on one the lines in this line-chart--you see the term Series.
In an example here it says Latin America. I should point to Jun there. But if you click the line itself or point to the line itself after having moved to somewhere else, you'll see it's the Series Latin America. Or up here, this the series Europe, and off to the left, you can see the data as well. In fact, I click on it, the data will highlight too. You've learned to kind to keep an eye on that, and you sort of absorb the meaning of these terms without really making a studied list of them. There is a pie chart to the right, a 3D pie chart.
Let's click on the pie chart, and once again we see that word Series. Often a series will refer to a row of data, as it appears to be in these examples, but there is another chart off to the left. This is a column chart of a different nature that's clustering data a little bit differently than you might see in another charts. I'll click on one of the columns here, slide the mouse over it. That's June and it's part of a series for Jun. Move away from it. Slide over it again. June. There the series refers to something vertical, part of a column, and here is a 3D chart here.
I'm sliding the mouse over the chart area. The chart area nearly always refers to the outer perimeter area of a chart. The inner part that holds the actual image is generally referred to as the plot area, we see right there. In this 3D chart--I'm pointing to the left-hand side there--Sidewall. It's a term we have not seen in the other charts. Back here a Back Wall, and you've probably figured out by now, what do we see at the bottom here? This is called Floor. And there's another chart down here below the data, a different chart related to different data, and there is a gridline. Clicking on the chart first before you see these.
That's a major gridline and here are one of those minor gridlines. Another thing you recognize too and it is important to start picking up on the names, there will be times when you want to change one of these chart elements, maybe make a line thicker or change its color, and many times you will right-click on the choice to do that. Sometimes though you will have difficulty and actually picking or selecting. This chart here at the bottom here that I'm moving the mouse around has some problems with it.
It's not quite ready to be printed. And one of the series here, the miles per gallon represented by a red, is difficult to click on. So here's something else you'll note. I'm going to click in this chart on the chart area. In the Ribbon at the top of the screen, here's a Layout tab, and the left-most portion of this called Current Selection, you see the term Chart Area. That's the same one we saw when we clicked on the chart. I'm going to click the drop arrow here. Here are all possible elements within this chart, and if I really need to get to that MPG series, I'll click it right here, and now it's selected.
So right below this it says Format Selection. I could click there and make some changes. So as you use charts, you'll see these terms all the time, and again, without really making a studied effort to memorize them all, you'll slowly pick up on them, and it will help you understand charts, and it'll help immensely as you use the various chart tools when you want to make changes to them throughout the use of charts in Excel 2007.
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.