# Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More

Microsoft    |    Expert
• 11 videos | 1h 39m 29s
• Includes Assessment
Rating 4.5 of 159 users (159)
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

• 3.  Creating Multi-category Box-and-whisker Plots
• 4.  Creating Colored Box-and-whisker Plots in Excel
• 5.  Visualizing Hierarchical Data Using Sunburst Charts
• 6.  Visualizing Cumulative Data Using Waterfall Charts
• 7.  Visualizing Related Tasks Using Gantt Charts
• 8.  Creating Basic Band Charts in Excel
• 9.  Finding Relationships in Data Using Scatter Charts
• 10.  Measuring KPI Progress Using a Waffle Chart
• 11.  Course Summary

## 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.6 of 30 users (30)
Rating 4.5 of 177 users (177)
Rating 4.5 of 99 users (99)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.2 of 10 users (10)
Rating 4.4 of 6009 users (6009)
Rating 4.2 of 266 users (266)