Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Great Graphs
Welcome!
Important Course Info
Ann's Contact Info
Monthly "Office Hours" Webinars for Silver and Gold Students
One-to-One Consultation for Gold Students
Introduce Yourself to the Group
What Makes a GREAT Graph? (9:37)
Analyze Your Audience
Who's Your Audience? (1:28)
Technical or Non-Technical? (5:12)
How Many Points in Time? (4:13)
How Many Decimal Places? (2:00)
Comparison Data? (1:16)
Are Viewers Expecting a Story? (5:14)
Choose the Right Dissemination Format
Which Format is Best for Each Viewer? (3:40)
The 30:3:1 Approach to Reporting (7:52)
Tool: Communications Crosswalk
Tool: Communications Plan
Choose the Right Chart
Consult a Chart Chooser (3:07)
Explore Your Dataset (2:53)
Sketch Drafts by Hand (8:50)
Explore Your Data with Sparklines
Insert Miniature Line Graphs Called Sparklines (2:32)
Insert Miniature Column Charts Called Column Sparklines (1:56)
Insert Win/Loss Sparklines (2:25)
Adjust the Vertical Y-Axis (6:37)
Add Markers (5:26)
Add New Data and Update the Data Source (4:16)
Adjust the Data Source Even More (Two Advanced Nuances) (2:26)
Remove (Clear) the Spark Lines Altogether (1:55)
Explore Your Data with Data Bars
Insert Miniature Bar Charts Called Data Bars (2:15)
Data Bars are Helpful Down Columns (But Not Across Rows) (4:10)
Adjust the Label Placement (i.e., Don't Place the Number on Top of the Bar) (15:39)
Adjust the Horizontal X-Axis (4:29)
Adjust the Color (7:34)
Adjust the Background Shading (i.e., Create a Stacked Bar Chart) (4:11)
Change Your Mind? Remove the Data Bars Altogether
Pies, Donuts, Square Pies, and Waffles
7 Guidelines for Pies & Donuts (7:47)
When Pies and Donuts Are Okay (1:16)
Alternatives to Pies & Donuts (4:47)
Square Pies, Waffles, & Icon Arrays (5:49)
Pie Chart Makeovers
From a 7-Slice 3D Pie to Bars with Icons (4:40)
From Unlabeled Pie Charts to a Comprehensive Dashboard (12:58)
From Four Different Pies to Stacked Columns (8:08)
Your Turn: Workforce Diversity
Your Turn: Mine Operator Employees
Bar Charts
Bar Chart Nuances: Scaling, Shading, Collapsing, Diverging, and Small Multiples (10:28)
There's Nothing More Boring Than a Report Full of Bar Charts... Area, Square Area, & Tree Maps (5:59)
How to Declutter Your Cluttered Stacked Bars (8:26)
Choose the Right Chart, continued
Lollipops & Dot Plots (6:35)
Progress Towards Goals (2:38)
Histograms & Population Pyramids (2:47)
Sankey & Chord Diagrams (4:46)
Before/After Comparisons (Clustered, Deviation, Slopes, Dots) (4:31)
Lines & Spaghetti Lines (5:25)
Maps! Geographic, Pin Drop, Tile Grid, Hex, and Cartograms (12:00)
Your Turn: Adding Visuals to an Annual Report
Ideas for Visualizing Qualitative Data
How to NOT Visualize Qualitative Data... (2:51)
3 Scenarios Where It's Okay to Use Word Clouds (9:05)
How to Make Word Clouds (8:56)
Annotate Your Quant Charts with Qual Data (4:53)
Color-Coded Phrases (5:21)
Sample Quotes with Photographs (9:34)
Add One Icon Per Paragraph, Takeaway Finding, or Theme (5:39)
Explain Complicated Processes with Diagrams (6:20)
Your Turn: Share Additional Examples & Resources
Chart Choosing Practice
Yes/No Survey Questions (3:44)
Check All That Apply (5:50)
Rating Scales (4:13)
Open-Ended Survey Comments (3:36)
Demographic Data on Survey Respondents (3:36)
Pre/Post Results (7:01)
Select a Software Program
Which Tools Are Available? (2:52)
Which Tool Do I Need for Which Chart??? (4:01)
Excel
Tableau
R
Power BI
Datawrapper
Write Your Reports in PowerPoint (Instead of Word!) (2:18)
Tell a Story
Tell a Story: Slope Chart Example (9:37)
Tell a Story: Bar Chart Example (3:54)
Declutter
Remove Unnecessary Ink & Apply the Squint Test (2:41)
Remove Borders (1:50)
Add White Outlines (2:05)
Remove 3D (3:02)
Remove Decorative Clip-Art... and Add Icons (3:33)
Four Places to Find Icons (13:01)
Remove Redundant Labels (6:14)
Remove Legends... and Label Directly (6:33)
Makeover 1: Tables (4:37)
Makeover 2: Cluttered X-Axis Dates (5:07)
Makeover 3: Repetition Everrrrywhere! (8:21)
Makeover 4: Redundant Tables & Graphs (9:22)
Your Turn: Declutter this Map!
Your Turn: Declutter *Your* Visualization
Clarify Your Message with Color
Brand Visuals with Custom Colors (2:59)
Find Color Codes in Style Guides (6:13)
Find Color Codes with Eyedroppers (5:40)
Find Color Codes from a Website's Page Source (2:45)
Find Color Codes with MS Paint (3:19)
Enter Color Codes in Excel (6:00)
Save Time! Create Theme Colors in Excel (8:07)
Color Inspiration If You Don't Have a Style Guide (13:38)
Ensure Legibility for People with Color Vision Deficiencies (9:26)
How to Test Your Color Palette & Your Dataviz Drafts for Color Vision Legibility (8:09)
Ensure Legibility for Grayscale Printing (& How to Test Your Graphs for Grayscale Legibility with Free Tools) (7:18)
Ensure Foreground/Background Contrast (& How to Test Drafts for Contrast with Free Tools) (6:53)
Color-Code Strategically (3:17)
Binary (1:53)
Sequential (1:19)
Diverging (4:10)
Categorical (7:56)
Highlights and Warnings (5:39)
Preattentive Attributes (4:37)
Your Turn: Re-Color This Graph! (Easy)
Your Turn: Re-Color This Map! (Advanced)
Your Turn: Re-Color *Your* Visualization
Clarify Your Message with Text
Brand Visuals with Custom Fonts (1:58)
Find Fonts in Style Guides (4:49)
State the Story in the Title (3:11)
Annotate (5:55)
Establish a Text Hierarchy (4:01)
Make Sure Text is Horizontal (3:17)
Use ALL CAPS Sparingly (1:27)
Improve Text Readability (14:12)
Your Turn: Re-Write the Text for *Your* Project
Before/After Data Visualization Makeovers
When Your Reports, Not Your Readers, Are The Problem (1:52)
Reenvisioning a University's Annual Report (12:27)
Workshop Evaluation Results (10:50)
Annual Survey Results (12:26)
Getting Started with Excel
Set Up Your Table and Insert a Brand New Chart (5:37)
Declutter the Chart (7:52)
Add Numeric Labels to a Chart (3:08)
Re-Order the Bars (3:33)
Reduce the Awkward White Space Between the Bars (2:36)
Brand with Custom Fonts (5:03)
Brand with Custom Colors (7:04)
Re-Size the Chart (and Text) (4:39)
Tell a Story with Dark Colors (4:28)
Tell a Story with a Title, Subtitle, and/or Annotation (7:25)
Move the Chart From Excel into Word or PowerPoint (6:15)
Emma Perk and Lyssa Becho on Creating One-Page Reports
What is a One-Page Report? (What is a one-pager and why would you want to create one?) (4:39)
Building the Foundations (Identifying Audience, Purpose, Prioritize Information) (5:29)
Visual Strategies (Choosing a grid, drafting layout, intentional path, hierarchy, white space) (6:11)
Final Touches (Feedback, Triple Check, Wrap-up) (5:48)
Jon Schwabish on Better Tables
Rules of Better Tables & Table Remakes (27:47)
Elissa Schloesser on Creating a Beautiful Report Cover
Getting Started: Why Cover Design is Important (0:52)
Lessons Overview (0:58)
Content (2:54)
Layout (5:17)
Style (6:27)
Pulling It All Together (3:36)
Advanced Excel Vizardry: Waffles
Step 1: Set Up Your Table (2:57)
Step 2: Insert a 100% Stacked Bar Chart (2:13)
Step 3: Declutter (3:53)
Step 4: Re-Size the Graph (5:16)
Step 5: Remove the White Space (0:54)
Step 6: Re-Color the Graph (6:19)
Step 7: Make the Remaining Waffle(s) (11:48)
Advanced Excel Vizardry: Dot Plots
Step 1: Transform Your Original Table into a Magic Table (9:30)
Step 2: Insert a Scatter with Straight Lines and Markers (2:17)
Step 3: Declutter (3:36)
Step 4: Make the Lines Skinnier (1:18)
Step 5: Remove the Zig-Zag Line (1:45)
Step 6: Make the Placeholder Line and Placeholder Dots White (2:28)
Step 7: Remove the Awkward Gray Line Along the Very Top (1:05)
Step 8: Re-Size the Dots (1:44)
Step 9: Re-Color the Dots (1:39)
Step 10: Add Numeric Labels (2:20)
Step 11: Apply Custom Colors and Fonts (1:36)
Step 12: Re-Size the Graph and the Font Sizes (4:37)
Step 13: Finalize the Built-In Legend (3:26)
Step 14: Add Category Labels (4:16)
Bonus! 2 Dots Without a Connecting Line (4:21)
Bonus! 1 Set of Dots (a Lollipop Graph) (4:23)
Bonus! Smaller Dots with Labels Beside Dots (Instead of Labels Inside the Dots) (3:02)
Bonus! Dots with Arrows (8:35)
Deven Wisner on Getting Started with Tableau
Exploring License Types & Downloading Tableau (7:29)
Tableau Compatible Data Sources (2:16)
Connecting Your Data Source to Tableau (1:05)
Data Formatting in Tableau (1:51)
Understanding Joins in Tableau (2:40)
When and How to Use a Union in Tableau (1:49)
From Sheets to Dashboards and Stories (3:31)
Sharing Your Tableau Workbook (3:14)
David G. Keyes on Getting Started with R
Why R? (4:51)
What is R? (5:29)
Working with Data in R (8:10)
ggplot and the Grammar of Graphics (10:30)
Data Viz Tricks (7:54)
Wrapping Up (2:13)
Echo Rivera on Effective Presentation Design
Download the Handout
When Does Slide Design Matter? (13:14)
Your #1 Enemy to Delivering Effective Presentations (7:25)
How Default Templates Set You Up to Fail (16:21)
What to Do Instead of Using a Template: Core Information Design Principles to Use Instead (28:56)
Handout Answer Key
Kylie Hutchinson on Effective Reporting
Is Anyone Reading Your Reports? (5:40)
Layering (5:19)
Identifying Key Messages (4:28)
Reorder Your Key Messages (4:26)
Designing Reports
What Makes a Great Report? (2:27)
Go Beyond the Report (7:07)
Scrollytelling (3:56)
Using Landscape Orientation (5:41)
Start With the "So What?" (1:35)
Visually Chunk Content With Dividers (3:17)
Apply a Text Hierarchy (2:29)
Go Beyond the Bar Chart (1:45)
Tell a Story With Dark Colors and Interpretive Text (1:49)
Add a Cover (4:32)
Designing Dashboards
What Makes a Great Dashboard? (5:13)
What is a Dashboard? The Official Definition (1:14)
Dashboard Types and their Tools (3:27)
A Single Static Dashboard (3:10)
A Series of Matching Dashboards (2:25)
Interactive Dashboards (2:43)
Sheila B. Robinson on Great Photographs
Lesson 1 (9:59)
Lesson 2 (16:33)
Lesson 3 (16:25)
Nick Visscher on Time-Saving PowerPoint & Excel Tips
Embedding Fonts (3:33)
Dynamic Excel Tables to Automatically Update Charts (3:52)
Intentionally Sort Rating Scale Data in Survey DataViz (3:50)
Embedding Non-Data Labels Into Charts (5:41)
Advanced Excel Vizardy: Small Multiples Bar Charts
Intro & Materials (2:35)
Step 1: Transform Your Original Table into a Magic Table (3:49)
Step 2: Insert a 2-D Horizontal 100% Stacked Bar Chart (1:57)
Step 3: Adjust the Colors (6:17)
Step 4: Declutter (2:38)
Step 5: Reduce the Vertical Gap between Bars (1:56)
Step 6: Add Labels to the Inside of the Colored Bars (3:05)
Step 7: Or, Add Labels to the Outside of the Colored Bars (5:09)
Step 8: Adjust the Graph's Size (3:11)
Step 9: Match the Fonts and Colors to the Recipient's Brand Guidelines (3:14)
Step 10: Label the Groups at the Top (12:14)
Bonus! Display a Different Number of Graphs (2:25)
Bonus! Display Numbers Instead of Percentages (3:20)
Bonus! Display Vertical Columns instead of Horizontal Bars (3:53)
Advanced Excel Vizardry: Population Pyramids
Intro & Materials (1:35)
Step 1: Set Up Your Original Table and Magic Table (4:59)
Step 2: Highlight the Gray Area and Insert a 2-D Horizontal 100% Stacked Bar Chart (2:21)
Step 3: Adjust the Colors So You Can See the Population Pyramid (3:27)
Step 4: Declutter (2:35)
Step 5: Reduce the Vertical Gap between Bars (1:14)
Step 6: Add Labels to the Inside of the Colored Bars (3:18)
Step 7: Or, Add Labels to the Outside of the Colored Bars (5:36)
Step 8: Adjust the Graph's Size (2:09)
Step 9: Add Age Range Labels Down the Middle (3:52)
Step 10: Match the Fonts and Colors to the Recipient's Brand Guidelines (2:50)
Step 11: Label the Groups at the Top (12:02)
Explore Your Data with Heat Tables
Intro & Materials (1:21)
Step 1: Insert a Heat Table (6:33)
Step 2: Sort the Data (4:18)
Step 3: Add White Outlines (2:01)
Step 4: Match the Fonts and Colors to the Recipient's Brand Guidelines (3:19)
Step 5: Make Sure Fonts are Legible Against Dark Backgrounds (5:17)
Step 6: Share the Table as a PDF (17:24)
Step 7: Undo the Heat Table (2:10)
Next Steps
Next Steps
Recommended Resources
Get in Touch
Step 14: Add Category Labels
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock