Aspire     Data Visualization Mastery     Data Visualization Track 1: Data Visualization with Excel

---

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.

---

---

Objectives

Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More 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