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.
Trends: Line charts - Microsoft Excel Tutorial
From the course: Picking the Right Chart for Your Data
Trends: Line charts
- [Instructor] If making comparisons is the most common use of data visualization, showing change over time has to be in second place. They're probably both fighting for first place, really. The first thing some people think of when communicating things over time, is a timeline. We've seen these used for hundreds of years to communicate time-dependent information, such as historical events, as in this example from 1769. But communicating quantitative data that changes over time also has a go-to default chart, just like communicating comparisons has bar charts as its default. For trends, the default is definitely the line chart. Like the bar chart, the line chart was invented by William Playfair, and is one of those ubiquitous charts that most people have seen and have a very clear ability to interpret. And you can have competing lines, and it can still make perfectly good sense. In fact, using smart design and…
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
-
-
-