Viewers: in countries Watching now:
Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Plus, learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.
When you're creating charts and changing chart types, certain terms are likely to appear frequently. Some charts are clustered, some are stacked, some are 100% stacked. Let's take a look at one of the charts, for example, on this worksheet chart data. If we click the chart below this. This might be the ideal chart. Maybe you're not sure. You might want to change the chart type. On the Ribbon you'll see the term Design, off to the right, Change Chart Type. Recognize the term Clustered Column.
That's the kind of chart we're seeing right now. Perhaps the most common chart type, it's likely to be the default chart type as you work with Excel, too. Notice another choice to the right of it is called Stacked Column, and we'll talk later about the advantages and disadvantages of that. And then another choice called 100% Stacked Column. Now we see those terms with columns, if we decide to use a bar chart we'll see those same terms. A clustered bar, a stacked bar, a hundred percent.
On a line chart, we don't see that term clustered but we will see a stacked line. And also, 100 percent stacked line. And with area charts, we'll see these as well. And so at different times when you work with different chart types. You will see these terms. That's a standard area chart. It doesn't really have a word in front of it, just like line. Here's a Stacked Area chart and 100% Stacked Area as well. And even with combo charts we'll see these terms, but in a different way. There's a Clustered Column in line. And here is a Clustered Column Line Secondary Access. Here's on Stacked Area Clustered Column.
So those terms clustered and stacked at 100%, we will see at different times. Of those three, perhaps the one most of you will not be using very often, is the called 100% Stacked Column, but it does have it's specialized uses. And so as we start to work with different chart types, again, recognize these terms, 100% stacked, stacked, and perhaps most common, clustered. And here we're seeing them with columns.
There are currently no FAQs about Excel 2013: 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.