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

Microsoft Excel 365    |    Expert
  • 11 Videos | 1h 43m 59s
  • 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

  • Playable
    1. 
    Course Overview
    2m 51s
    UP NEXT
  • Playable
    2. 
    Displaying Statistics Using Box Plots in Excel
    10m 54s
  • Locked
    3. 
    Creating Multi-category Box-and-whisker Plots
    9m 36s
  • Locked
    4. 
    Creating Colored Box-and-whisker Plots in Excel
    5m 1s
  • Locked
    5. 
    Visualizing Hierarchical Data Using Sunburst Charts
    11m 10s
  • Locked
    6. 
    Visualizing Cumulative Data Using Waterfall Charts
    10m 50s
  • Locked
    7. 
    Visualizing Related Tasks Using Gantt Charts
    12m 6s
  • Locked
    8. 
    Creating Basic Band Charts in Excel
    11m 3s
  • Locked
    9. 
    Finding Relationships in Data Using Scatter Charts
    11m 52s
  • Locked
    10. 
    Measuring KPI Progress Using a Waffle Chart
    10m 59s
  • Locked
    11. 
    Course Summary
    3m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.