This is an Eval Central archive copy, find the original at depictdatastudio.com. I recently saw a graph that looked like this—accidentally combining 3 different units on the same chart: In this 8-minute lesson, you’ll learn: (1) how small multiples layouts can help, and (2) how to make small multiples charts in Excel. What’s Inside 0:00 […]
Visualizing Percent Changes
This is an Eval Central archive copy, find the original at depictdatastudio.com. How are you visualizing percent changes? I recently saw a boring, black and white table as I was scrolling through LinkedIn. The topic caught my attention—it was about Hispanic adults living with HIV—but the poorly-formatted table wasn’t making the patterns easy to understand. I […]
Excel chart with too much blank space – HELP!
This is an Eval Central archive copy, find the original at depictdatastudio.com. In this tutorial, you’ll learn how to fix Excel charts that have too much empty space: What’s Inside 0:00 Intro 0:28 Lindsey’s question 0:54 Outside chart borders 1:19 Inside chart borders 1:56 Unsolicited dataviz editing 15:30 Before and after Resources Mentioned Video about […]
Live Dataviz Design
This is an Eval Central archive copy, find the original at depictdatastudio.com. Want to watch me work? Here’s a collection of livestreams:
Fixing a Donut Chart
This is an Eval Central archive copy, find the original at depictdatastudio.com. Which one’s your favorite? What’s Inside 0:00 Welcome 0:30 1. The before version 1:25 2. Table 1:36 3. Heat table 1:42 4. Donuts 2:05 5. Donuts with top icons 2:43 6. Donuts with side icons 2:58 7. Icon array 3:05 8. Icon array […]
Which Graphs Can I Make in Excel?
This is an Eval Central archive copy, find the original at depictdatastudio.com. Sure, Excel can handle bar charts and line charts. But it can also make population pyramids, dot plots, and maps! In this video, you’ll see more than a dozen different charts that are possible inside Microsoft Excel. What’s Inside 0:00 Intro 0:17 Dataviz […]
Tables with Check Marks (in Excel!)
This is an Eval Central archive copy, find the original at depictdatastudio.com. I recently saw two (!) of these tables within the same week: In this tutorial, you’ll see a few ideas for transforming tables with check marks. These tiny tweaks can be accomplished in everyday software like Excel. What’s Inside 0:00 Intro 0:18 The […]
Designing a 2-Page Infographic: NIH Grant Terminations
This is an Eval Central archive copy, find the original at depictdatastudio.com. I ignored my inbox and turned a boring table into a 2-pager. What’s Inside 0:00 The 2-pager about NIH grant terminations 2:20 Lookup table with Stateface icons 2:38 Original table from the policy brief 2:47 The dataset 2:58 Idea 1: A better table […]
Concatenation in Excel
This is an Eval Central archive copy, find the original at depictdatastudio.com. “Concatenation” means pushing things together, chaining things together, or joining things together. It’s the opposite of pulling apart (techniques like text to columns, textsplit, etc. in Excel). What’s Inside 0:00 Welcome 0:15 What is concatenation?? 0:22 Pushing together vs. pulling apart 0:45 Download […]
Show MORE Points in Time On Your Graph!!!
This is an Eval Central archive copy, find the original at depictdatastudio.com. If you have TONS of points over time… show tons of data in your graph! Too often, I see organizations show just a single point in time. A single number is meaningless. We need at least two numbers — preferably three, four, or […]