Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 76701 Viewers
80 Video lessons · 130883 Viewers
52 Video lessons · 64776 Viewers
59 Video lessons · 50605 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.