Overview/Description
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.
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