This is an Eval Central archive copy, find the original at depictdatastudio.com. Are you printing or PDFing that Excel table? If it’s a long table, and spills onto a second page, then you’ll need to keep the table headings in view. Here’s how you can repeat a few rows at the top of each page. […]
Dotted Lines are for Projections (& How-To Instructions for Excel)
This is an Eval Central archive copy, find the original at depictdatastudio.com. Dotted lines have a specific purpose in dataviz: for projections or estimations. Not just because. Stick around for the how-to lesson in Microsoft Excel. You’ll learn how to select a single dot (or “marker”) along the line, which controls the preceding line segment. […]
Color on Color – Is This Readable??? Short Answer (NO!) & Long Answer (Official Contrast Checker)
This is an Eval Central archive copy, find the original at depictdatastudio.com. Is “color on color” hard to read? Short answer: YES. Long answer: Let’s do an official color contrast check: https://webaim.org/resources/contrastchecker/ You’ll also see how to fix it. What’s Inside 0:00 Intro to Yellow on Red Example from Workshop 0:16 The Short Answer (Avoid […]
How to Fix Dense Maps (with Small Multiples)
This is an Eval Central archive copy, find the original at depictdatastudio.com. A good rule of thumb: If your map feels too dense… try small multiples! Before, we started with a single map… with 2 variables. Counts and rates. A bubble map on top of a heat map. After, we’ll use small multiples: 2 separate […]
STOP!!! Using Colored Body Font
This is an Eval Central archive copy, find the original at depictdatastudio.com. Brand colors are great. Color-coding by category is greater. But avoid using those brand colors as body font within paragraphs. Colored font is okay for headers, but not for the body. What’s Inside 0:00 Intro 0:31 Before: Example from a Public Workshop 1:33 […]
How to Make Interactive Dashboards in Excel (30-Min Demo & Files to Download)
This is an Eval Central archive copy, find the original at depictdatastudio.com. Did you miss my Good Tech Fest conference session? Catch the replay here! Materials Follow along with the spreadsheet: https://depictdatastudio.gumroad.com/… You’ll have to watch the video to get the coupon code. There are codes available for the first 500 people. Chapters 0:00 Intro […]
How to Copy/Paste Graphs from Excel into Word or PowerPoint
This is an Eval Central archive copy, find the original at depictdatastudio.com. You’ve got two options. (Well, if you like to split hairs, there are more options than that. But what if you’re busy and don’t have time to lose? Here are the main copying/pasting options worth paying attention to.) Option 1: Excel Object a.k.a. […]
How to Visualize Population Projections with Small Multiples Population Pyramids
This is an Eval Central archive copy, find the original at depictdatastudio.com. A few months ago, one of my favorite students brought this graph to Office Hours: (These aren’t the exact numbers, age ranges, or years. But you get the idea.) She already knew how to make population pyramids in Excel. Population pyramids require Level […]
Looking Ahead to 2024: What’s Coming to Depict Data Studio
This is an Eval Central archive copy, find the original at depictdatastudio.com. Wondering what I’ve got planned this year? Here’s what’s in store for 2024 related to: Online Courses, Private Training, Conference Keynotes, and My Personal and Professional Goals. Online Courses The biggest improvement for 2024 is that all 6 courses will be offered LIVE […]
Top 23 Dataviz Resources of 2023
This is an Eval Central archive copy, find the original at depictdatastudio.com. 9,200 total participants in my dataviz courses so far (and ~25,000 taught in-person and virtually over the past decade). A dozen in-person workshops (with trips to Dubai & Tanzania) and several dozen virtual workshops. 32 new blog posts: 28 from me, and 4 from […]