This is an Eval Central archive copy, find the original at depictdatastudio.com. Maybe you’re already familiar with dot plots… Maybe you’re already using them… Maybe you can make ’em in your sleep… Or maybe you have no idea what I’m even talking about! (If that’s the case, stick around! This video is for you.) You’ll […]
How to Add Checkboxes to Microsoft Excel **New Feature!**
This is an Eval Central archive copy, find the original at depictdatastudio.com. Did you know… that Excel now has checkboxes?!? In this video, you’ll learn: how to add checkboxes to your spreadsheet, how much better they look than the “old” way of doing it, and what types of details we can edit (like the checkbox […]
How to Label Only the Min and Max on the Excel Graph
This is an Eval Central archive copy, find the original at depictdatastudio.com. By default, Excel will label TONS of increments along our y-axis scale. And if we’ve already got the exact values within the graph itself, the y-axis can become even more cluttered. In this video, you’ll learn how to adjust your graph’s vertical scale […]
How to Move Lines to Front or Back of the Chart in Excel
This is an Eval Central archive copy, find the original at depictdatastudio.com. Do you have a line chart with tons of lines? Sometimes, the line you want to highlight… is stuck all the way in the back. Nobody can see that line, because it’s all covered up. Oops! In this video, you’ll learn how to […]
Style Guides vs. Dataviz Style Guides vs. Templates
This is an Eval Central archive copy, find the original at depictdatastudio.com. Style guides, dataviz style guides, and templates, oh my! In this video, you’ll learn about the differences between each one, and see some quick examples, too. https://www.youtube.com/watch?v=npGR0ND8Vf4 What’s Inside 0:00 Welcome 0:28 Ann’s Diagram re: Your Branding Resources 0:47 Variations by Company/Organization 1:27 […]
Private Data Visualization Workshops: What’s Inside?
This is an Eval Central archive copy, find the original at depictdatastudio.com. I offer full-day workshops on 6 different topics. All of these classes fall under the broad data communications umbrella. You can choose from these 6 classes: Simple Spreadsheets Great Graphs Great Graphs in Excel Report Redesign Dashboard Design Powerful Presentations One class focuses […]
Your Dataviz Icons: Too Big and Too Dark?
This is an Eval Central archive copy, find the original at depictdatastudio.com. If your boss doesn’t like your icons… they’re probably too big and too dark. Just like all your graphs, maps, and diagrams, your icons deserve some TLC, too. Icons can get cartoonish or steal the show if they’re not formatted well. What’s Inside […]
How to Make Maps in Excel (& File to Download)
This is an Eval Central archive copy, find the original at depictdatastudio.com. This tutorial was inspired by a foundation I work with. We were brainstorming what type of map to make. Maybe a color-coded map, showing how many grants they gave out in each state? Maybe a one-color map, showing which states they worked in […]
Breaking Barriers with Accessible Data Visualization
This is an Eval Central archive copy, find the original at depictdatastudio.com. A couple months ago, I recorded a podcast about Big A and little a accessibility. Today, it’s live! You can listen here: https://em360tech.com/podcast/breaking-barriers-data-visualization This is a short listen (15 min) with some techniques that are hopefully super obvious if you’ve been following my work […]
How to Write Dynamic Takeaway Sentences inside Interactive Excel Dashboards
This is an Eval Central archive copy, find the original at depictdatastudio.com. I’m a big fan of takeaway text: for reports, for presentations, and even for interactive dashboards. Sometimes people think that takeaway text isn’t possible for dynamic dashboards in Excel. They worry that they’ll have to write each sentence by hand. False! In this […]