From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
Unlock this course with a free trial
Join today to access over 24,600 courses taught by industry experts.
Pies, donuts, and race tracks - Microsoft Excel Tutorial
From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs
Pies, donuts, and race tracks
- [Instructor] Alright, next up we've got pie and donut charts. I'm sure you already know what a pie chart is, one of the most basic chart types out there, it's really just used to compare proportions totalling 100%. But if you don't know much about donut charts, you'll probably want to pay attention, because donut charts aren't just pie charts with the center cut out, which is how they got their name, but they also introduce some capabilities that go well beyond what a pie chart can do. So for instance, you can add multiple rings to a donut chart like this, to show additional data series or metrics within the same visualization. Can also get clever and build some sort of a racetrack or pacing style visualization like this, which I'll show you in just a minute. So examples of when you'd use either a pie or a donut chart, anything that adds up to a percentage of a whole, so percentage of budget by department, internet users by age range, a breakdown of site traffic by source, you get…
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
-
-
-
-
-
(Locked)
Bar and column charts8m 49s
-
(Locked)
Histograms and Pareto charts5m 58s
-
(Locked)
Line charts and trendlines5m 16s
-
(Locked)
Area charts4m 41s
-
(Locked)
Pies, donuts, and race tracks12m 4s
-
Scatter plots7m 30s
-
(Locked)
Bubble charts6m 36s
-
(Locked)
Box and whisker charts6m 5s
-
(Locked)
Tree maps and sunburst charts6m 36s
-
(Locked)
Waterfall charts3m 17s
-
(Locked)
Funnel charts3m 42s
-
(Locked)
Radar charts7m 56s
-
(Locked)
Stock charts7m 18s
-
(Locked)
Heat maps4m 41s
-
Surface and contour charts7m 35s
-
(Locked)
Geospatial maps (Power Map)5m 28s
-
(Locked)
Basic combo charts7m 57s
-
(Locked)
Sparklines2m 7s
-
(Locked)
-