depictdatastudio

This is an Eval Central archive copy, find the original at depictdatastudio.com. Sure, you can add anything and everything to your dashboard. (Here’s a running list of all the great graphs you can make in Excel.) In this article, you’ll learn about 20 stress-free charts that we can make inside spreadsheet software like Microsoft Excel. These visuals […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. If you’ve got a column chart with lots of labels, chances are, the labels have gotten twisted diagonally, like this: Diagonal text takes longer to read than plain ol’ horizontal text, so we want to avoid it. In this lesson, you’ll learn 5 […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Are you presenting online? Are you sharing the replays with attendees? Captions increase the accessibility of our recordings, making it easier for attendees with hearing issues, audio/tech glitches, and non-English speakers to follow our ideas. In this lesson, you’ll learn about embedded captions […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. During Office Hours, Sue Griffey walked us through the pros and cons of 3 different mapping approaches: Pin drop maps (made for free with Google) Heat maps (made with Excel) Tile grid maps (also made in Excel) Overlay maps (tile grids, icon stacks, […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. You might need text boxes for annotations or labels. You might spend a few moments adding and editing the text box. But then, it doesn’t get pasted correctly into Word or PowerPoint, argh! In this 5-minute video, you’ll see 2 ways to add […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Is your chart… Too wide? Too narrow? Bars are too short? Weird white space? Labels not showing? Labels wrapped funny? If so, it’s probably the outside and/or inside border. If you’re not sure what I mean by outside and inside border, stick around! […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Want to put both the numbers and the percentages inside your Excel graph’s labels, like this? Text boxes are clunky and time-consuming. Instead, we’ll create Helper Cells with concatenated values. What’s Inside 0:00 Intro 0:33 Dataviz On The Go 0:42 Why not text […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. I have a love-hate relationship with maps in Excel… Pros of Excel Maps If you’re only making maps once in a while (i.e., you’re not a full-time cartographer), Excel maps are great because you don’t have to purchase/download/install/learn any specialty mapping software. Fast […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Ready for a brain-bending tutorial? It’s *not* easy to make dot plots in Excel. These are non-native charts — meaning we’ll have to reconfigure our table, and use a scatter plot(!) — to trick Excel into making our dot plot. The learning curve […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Colors can make or break a chart. Colors direct our eye movements, and therefore our brains and attention. It’s up to you: will you help or hinder your reader’s understanding? Step 1: Start with Your Brand Colors Otherwise, your graphs, slides, and dashboards […]