From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create and modify sunburst and waterfall charts
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Create and modify sunburst and waterfall charts
- [Instructor] Let's take a look at two more charts available to us in Excel 2019. In this video, we will be reviewing the sunburst and waterfall charts. Now, the sunburst chart gives us the best of both worlds, from pie charts and donut charts. As you recall, pie charts only let you chart out one data series, so it's very limiting. Sunburst charts, we don't have that limitation. And it's very similar, also, to a donut chart that shows hierarchical data. We'll also be taking a look at the waterfall chart. This is a great way to analyze profit and loss or if you want to create an inventory tracking system, or if you just need to do some other sales or data analysis. Well, let's take a look at our Sunburst_Waterfall workbook. We'll start with sunburst. My data has a specific customer, the first quarter and the category that shows how we shipped all of the orders to that particular customer, and here is the sunburst chart…
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)
Create and modify dual-axis and combo charts2m 47s
-
(Locked)
Create and modify box and whisker and funnel charts5m 55s
-
(Locked)
Create and modify histogram and map charts6m 27s
-
(Locked)
Create and modify sunburst and waterfall charts6m 39s
-
(Locked)
Create and modify PivotTables7m 44s
-
(Locked)
Create and modify PivotCharts6m 5s
-
(Locked)
Challenge: Manage advanced charts and tables28s
-
(Locked)
Solution: Manage advanced charts and tables5m 40s
-
(Locked)
-
-