Blog

Four Stats Formulas that Every Spreadsheet User Should Know About

Dec 10th, 2019 / Data Analysis

Summarizing datasets for use in your data visualizations doesn’t have to be time consuming and frustrating. This article will outline four statistical formulas that every spreadsheet user should know.

How to Add Dotted Lines to Line Graphs in Microsoft Excel

Nov 12th, 2019 / Data Visualization

What to do if you’re missing chronological data? Learn how to represent the missing data by turning solid lines into dotted lines.

Condensing Many Data Elements into an At-a-Glance Directory Using Symbols, Reference Codes and Colors

Oct 1st, 2019 / Dashboards

Guest author Anna Williams was tasked with developing a national directory of organizations working on sexual and reproductive health for one of the United Nations’ country offices. In this blog post, Anna gives you a behind-the-scenes peek at that searchable Excel database.

How to Aggregate Information Across Sites

Aug 20th, 2019 / Data Visualization

When you’re working in the weeds of a spreadsheet, it can be hard to step back and find the bigger … more »

How to Visualize Age/Sex Patterns with Population Pyramids in Microsoft Excel

Nov 13th, 2018 / Data Visualization

I recently worked with a state public health agency that wanted to depict how many males and females were diagnosed … more »

Five Simple Steps to Creating Home Visiting DataViz

Sep 17th, 2018 / Dashboards, Data Visualization, Reports

Here’s our second post about visualizing data for the National Home Visiting Resource Center.