Dotted Lines are for Projections (& How-To Instructions for Excel)
Depict Data Studio
by Ann K. Emery
3d ago
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. Then, you can turn just one section of the graph into a dotted line. https://www.youtube.com/watch?v=titF7TQcwDc What’s Inside 0:00 Don’t Use Dotted Lines “Just Because” 0:20 Dotted Lines are for Projections or Estimations 1:24 How to Make Dotted Lines on Excel Graphs 3:44 Questions ..read more
Visit website
STOP!!! Using Colored Body Font
Depict Data Studio
by Ann K. Emery
2w ago
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 After: Dark Dark Dark Gray Body Font 2:21 The Before-After Difference ..read more
Visit website
How to Make Interactive Dashboards in Excel (30-Min Demo & Files to Download)
Depict Data Studio
by Ann K. Emery
3w ago
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. What’s Inside 0:00 Intro 1:14 The 4 Steps 4:28 (1) Excel Table 12:36 (2) Pivot Tables 18:14 (3) Pivot Charts 20:47 (4) Slicer(s) 24:33 A Gift for You 25:55 Q&A ..read more
Visit website
How to Copy/Paste Graphs from Excel into Word or PowerPoint
Depict Data Studio
by Ann K. Emery
1M ago
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. Ann K. Emery’s preferred approach Instructions In Excel, create your graph. In Excel, format your graph. (Declutter; apply brand colors and dark-light contrast; delete the built-in title; re-size the font and graph; etc.) In Excel, make sure your Theme Colors and Theme Fonts are selected. In Word or PowerPoint, make sure your Theme Colors and Theme F ..read more
Visit website
How to Visualize Population Projections with Small Multiples Population Pyramids
Depict Data Studio
by Ann K. Emery
4M ago
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 4 vizardy skills. Woohoo! But she wanted to take the population pyramid a step further, and she wanted to show how the population might change over time, especially for older adults. So, she followed this online tutorial to add those curvy lines. (Yep, it’s made with a combo chart in Excel.) Bare-Minimum Edits As usual, we tackled the bare-min ..read more
Visit website
Looking Ahead to 2024: What’s Coming to Depict Data Studio 
Depict Data Studio
by Ann K. Emery
4M ago
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 (!!!). We’ll meet over Zoom on Monday, Tuesday, Wednesday, and Thursday afternoon from 1 – 4:30 pm Eastern each day. We’ll have 10 minute breaks every hour, and the last 30 minutes is reserved for extra Q&A time. Classes are highly interactive. I’l ..read more
Visit website
How to Bring Your Technical Tables to Life
Depict Data Studio
by Ann K. Emery
6M ago
Just because I’m pro-graph, I’m not anti-table. Technical tables have so much value, especially as visual appendices for reports. In this blog post, you’ll get ideas for bringing your technical tables to life. Before Here’s what the “before” version of some technical tables looked like. These are made-up numbers, but you get the idea. The public health staff wanted to look at quarterly numbers, the total annual number, and the rate (the number of cases per 100,000 live births). Even if you’re not measuring neonatal abstinence syndrome, I bet there are numbers that you track each quarter. You ..read more
Visit website
When Graphs Have Multiple Takeaway Messages
Depict Data Studio
by Ann K. Emery
7M ago
Sometimes our graphs have a single, overarching takeaway message. Maybe the numbers simply went up over time. Or down. Other times, it’s more complicated. Here’s how to explain multiple takeaway messages in presentations: with multiple slides, one per takeaway message. Before: Everything Smushed on One Slide Here’s what I typically see: lots of possible takeaway messages shoved into a single graph on a single slide. The presenter says something like this: “Next, let’s talk about gonorrhea diagnoses in our state. We’re looking at the number of diagnoses per 100,000 people. We’re also looking ..read more
Visit website
How to Visualize Confidence Intervals in Presentation Slides
Depict Data Studio
by Ann K. Emery
8M ago
Do you need to share statistics in presentations? Maybe you’re getting ready for a talk at a conference. Or, maybe you’re sharing updates with coworkers in a staff meeting. In this blog post, you’ll learn how to explain dense graphs one slide at a time, which makes it easier for our audience to follow along. Before Last summer, I was keynoting the National Birth Defects Prevention Network’s annual conference in Atlanta. Here’s what one of the health department’s original graphs looked like. We wanted to make a presentation-ready version. If you work in public health, then you know that the t ..read more
Visit website
How to Visualize Small n’s with Icon Arrays
Depict Data Studio
by Ann K. Emery
8M ago
I was recently working with an online course student to visualize data for her country’s government officials. These aren’t her real categories or real numbers, but you get the idea. Before: Reading Numbers Her “before” version looked something like this: She had small n’s — a unique situation! My definition of a “small” number is less than 100 — an arbitrary cut-off point that I learned from a past supervisor, and I’ve stuck with for years. Not only was the total under 100, but each of the cells was under 100, too. After: Skimming Visuals There are several ways to bring the table to life ..read more
Visit website

Follow Depict Data Studio on FeedSpot

Continue with Google
Continue with Apple
OR