Excel Data Visualization: Designing Custom Visualizations

Interested in using more than the built-in chart and graph tools to showcase your data in Excel? In this course—the second and final installment in the Excel Data Visualization series—instructor Chris Dutton steps through how to create unique, custom data visualizations in Excel. Since Chris covered the core data visualization capabilities of Excel in the previous installment of the series, he dives into some more sophisticated techniques here. As he moves through a series of hands-on demos, Chris covers everything from building dynamic dashboards to advanced maneuvers like value-based formatting and dynamic series selection.

Learning objectives
Explain how to define the elements in a thermometer chart.
Review the purpose of OFFSET and COUNTA functions.
Relate why a guardrail is used when creating scroll bars and zoom bars.
Examine the reason for using value-based dynamic formatting.
Determine what a gauge-and-needle chart is and how to create one.