From the course: Picking the Right Chart for Your Data
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Proportions: Pie charts and more - Microsoft Excel Tutorial
From the course: Picking the Right Chart for Your Data
Proportions: Pie charts and more
- [Instructor] If comparisons and trends are tied for first place in the number of visualizations ever made, then proportions market share is definitely second place. People are always using data to figure out the components of something. And not just the components, but how much of the whole those components comprise. And the first go-to visualization without a doubt is the pie chart. Once again, we have William Playfair to thank for this ubiquitous chart. The pie chart is absolutely the go-to chart for this kind of data because once again, it's been around for over 200 years. And because our software makes it so easy to create pie charts. But there are endless issues with pie charts that you need to be aware of. The short version, pie charts are only good at some things. So use them with caution. Now for a bit more background. First, let me start by acknowledging that research has proven that humans love round shapes,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Chart categories2m 19s
-
(Locked)
Comparisons: Bars and columns3m 44s
-
(Locked)
Comparisons: Beyond bars5m 49s
-
(Locked)
Trends: Line charts2m 45s
-
(Locked)
Trends: Beyond the line5m 19s
-
(Locked)
Proportions: Pie charts and more3m 48s
-
(Locked)
Proportions: Beyond the circle4m 1s
-
(Locked)
Relationships: Correlation5m 8s
-
(Locked)
Relationships: Hierarchical and network3m 25s
-
(Locked)
Relationships: Flow3m 3s
-
(Locked)
Distribution: Histograms2m 8s
-
(Locked)
Distribution: Beyond histograms5m 1s
-
(Locked)
Deviation4m 40s
-
(Locked)
Geographic5m 25s
-
-
-