From the course: Picking the Right Chart for Your Data
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Comparisons: Beyond bars - Microsoft Excel Tutorial
From the course: Picking the Right Chart for Your Data
Comparisons: Beyond bars
- [Instructor] We've looked at the king of all comparison charts, bar charts. Now, let's look at some alternatives. For instance, the lollipop chart. It's just like a column chart but with a bubble at the end of a line in place of the rectangle. Why use the lollipop instead of bars? Well, sometimes it can alleviate what's known as the Moire Effect when you have a lot of bars next to each other and it can be hard to look at. See the visual vibration in the white space between these bars? The Moire Effect is one good reason you don't wear pajamas on TV. TVs and other screens make the Moire Effect worse. Or maybe it's because you want to really draw attention to the actual values themselves, because in this case the dots are what draw your eye rather than the entire rectangle size. The value is emphasized, not just a comparison to its neighbors. Sticking with the same idea, how about a dot plot? Here we've taken the…
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
-
-
-