Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
Microsoft
| Expert
- 11 videos | 1h 39m 29s
- Includes Assessment
- Earns a Badge
Once you grasp how to work with the scope of standard Excel chart types, you can expand into more complex visualizations. For example, you can use box-and-whisker plots to convey a wealth of information about the statistical distribution of a variable and identify outliers in a data series. You can use sunburst charts to visualize hierarchical data with differing levels of detail, waterfall charts to show the cumulative effect of positive and negative values, and Gantt charts to illustrate progress toward a goal involving multiple parallel tasks. Additionally, you can avail of band charts to quickly eyeball the trend in a line chart, scatter plots to uncover the relationship between two variables, and waffle charts to visualize progress towards KPIs. In this course, you'll create all of these charts either via Excel's built-in tools or by building them manually using nifty workarounds.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Create a basic box-and-whisker plot to display various descriptive statistics of a variable, such as the mean, median, 25th percentile, and 75th percentile
Add labels to a box-and-whisker plot, create a box-and-whisker plot with two sets of boxes and whiskers grouped based on a category, and perform various formatting operations on this plot
Create a box-and-whisker-plot with separate categories on the x-axis and based on the color of the box, then add lines linking the means for all categories
Create a sunburst chart to visualize data with more than one level of hierarchy
Create a waterfall chart to show the cumulative effect of positive and negative values over a specified period of time to add up to a total final value -
Create a gantt chart out of a basic stacked bar chart
Create band charts to quickly visualize the trend in a line chart
Display the relationship between two variables and understand what kind of model might be most useful to represent that relationship
Create a waffle or kpi chart with a grid of percentages that update based on an index that in turn updates based on the value of a spin button
Summarize the key concepts covered in this course
IN THIS COURSE
-
2m 51s
-
10m 54s
-
3. Creating Multi-category Box-and-whisker Plots9m 36s
-
4. Creating Colored Box-and-whisker Plots in Excel5m 1s
-
5. Visualizing Hierarchical Data Using Sunburst Charts11m 10s
-
6. Visualizing Cumulative Data Using Waterfall Charts10m 50s
-
7. Visualizing Related Tasks Using Gantt Charts12m 6s
-
8. Creating Basic Band Charts in Excel11m 3s
-
9. Finding Relationships in Data Using Scatter Charts11m 52s
-
10. Measuring KPI Progress Using a Waffle Chart10m 59s
-
11. Course Summary3m 9s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE
Rating 4.5 of 177 users
(177)
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Rating 4.6 of 538 users
(538)
