Column and bar charts comprise the bulk of chart type usage for many Excel users.…Three terms that you're likely to encounter when using these kinds of charts as…well as others are the terms clustered, stacked, and 100% stacked.…Let's look at these with column charts and then point out how you'll also…encounter them with other chart types as well.…The chart to the right of the data here is a clustered column chart.…It's probably the default chart type in Excel, unless you've made a change to it, …and it's certainly one of the most common chart types.…
Now when you are creating charts or you're possibly changing charts, if you go…to the Design tab, Change Chart Type, this is where we see all those choices.…I'm just putting the mouse over this Clustered Column.…In line charts, you'll have roughly the equivalent, but you don't see the word Clustered.…We will see these as we point to bar charts. There's a Clustered Bar.…It's equivalent in area. You don't see that. And going back up here you will see…
Author
Released
6/15/2011- Identifying the plot area, chart area, gridlines, legends, and more
- Selecting the right chart type
- Creating charts instantly with shortcuts
- Choosing a layout
- Dealing with empty and hidden cells
- Switching rows and columns for a different view of the data
- Moving and resizing a chart
- Inserting pictures and shapes
- Adding labels to a chart
- Analyzing existing and future data with trendlines
- Changing a chart's data source
- Printing charts
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Managing and Analyzing Data in Excel 2010
with Dennis Taylor1h 32m Intermediate
-
Introduction
-
Welcome1m
-
-
1. Understanding Excel Chart Concepts
-
2. Creating Basic Charts Quickly
-
3. Fine-Tuning Charts with Design Tab Choices
-
Choosing a chart layout3m 22s
-
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
-
Adding shapes and arrows2m 58s
-
5. Layout Tab Options: Adding Titles, Labels, and Legends
-
Linking titles to content1m 52s
-
6. Layout Tab Options: Using Axes and Gridlines
-
Modifying axis scaling7m 55s
-
Working with gridlines4m 11s
-
-
7. Layout Tab Options: Using the Analysis Tools
-
Adding drop lines1m 11s
-
Adding error bars4m 34s
-
8. Format Tab Options: Adding Shapes and WordArt Styles
-
Adding shape effects5m 34s
-
Applying WordArt styles2m 1s
-
9. Using Other Formatting Tools
-
Formatting lines and borders3m 45s
-
Working with chart text2m 47s
-
-
10. Adjusting Specific Chart Types
-
Using column and bar charts9m 12s
-
Using line charts5m 25s
-
Using pie charts6m 30s
-
-
11. Changing a Chart's Data Source
-
12. Printing and Sharing Charts
-
Printing charts6m 41s
-
-
Conclusion
-
Next steps43s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Understanding chart terminology