Yearly Archives: 2013

3 (Really Good) Reasons Not to Use Gauges

Every August for the past 30 years, we have vacationed on Bustins Island in Casco Bay, Maine (check out my September 2011 newsletter about this slice of paradise). You can get to the island only by boat; for us, this … Continue reading

Share
Posted in Design Basics, Graphs, Newsletters | 3 Comments

Did You Answer the Question?

My husband Bret and I had a lively exchange the other morning about the previous night’s Red Sox game. I’d gone to bed while he stayed up late watching the last few innings, so when I woke up, the first … Continue reading

Share
Posted in Communicating Data to the Public, Data Analysis, Newsletters | 1 Comment

2013 Summer Reading List for the Healthcare Data Geek

When I go to the beach, I always make sure whatever book I take with me is wrapped in a brown paper cover. I imagine that it creates an air of mystery about me: perhaps I’m reading something really steamy … Continue reading

Share
Posted in Books, Newsletters | 1 Comment

Improving the Odds — Are You a Donor?

I have been following the case of Sarah Murnaghan, a dying 10-year-old girl who, after a federal judge granted her family’s emergency petition, has become eligible to seek donor lungs from an adult transplant list. In the petition, Sarah’s family … Continue reading

Share
Posted in Etcetera, In the News, Newsletters, Point of View | Leave a comment

How to Make a Vertical Bullet Chart

Anatomy of a Bullet Chart How to Make a Vertical Bullet Graph Making the Chart Step 1: Create your chart. Select cells E5 through G6 and select the “Insert” tab and in the “Charts Section” click the down arrow under … Continue reading

Share
Posted in Excel Tips & Tricks, Graphs | 1 Comment

A Profoundly Moving Data Display

This past Memorial Day I was greatly moved by news stories about the courage and sacrifice of so many in service to our country. It was also a quiet time for me to reflect on the memorials erected to commemorate … Continue reading

Share
Posted in Communicating Data to the Public, Data Analysis, Design Basics, Etcetera, Know Your Audience, Newsletters, Point of View, Tables | Leave a comment

Visualize a New Approach

Hey, guess what I did last week? My husband and I finally realized our dream of owning a boat. We even named it Visualize — for all the reasons you might imagine. Yes, I can hear you all chuckling from … Continue reading

Share
Posted in Graphs, Newsletters, Tableau | 1 Comment

How to Make a Gantt Chart for Repeated Tasks

A Gantt chart for repeated tasks consists of a bar chart series showing the duration of a task, stacked on a transparent bar that pushes the visible bar out to the start of the task. My technique added two more … Continue reading

Share
Posted in Editing Charts & Graphs, Excel Tips & Tricks | 23 Comments

How to Make a Gantt Chart

A Gantt chart is a horizontal bar chart often used in project management applications. The attached Excel workbook shows a Gantt chart set up to depict the schedule for a project in cell range A1: C13. The horizontal axis represents … Continue reading

Share
Posted in Editing Charts & Graphs, Excel Tips & Tricks | 1 Comment

Peace, Love, Joy and Personas

We keep this great stack of cards in the dining room: it’s called “TableTopics: Questions to Start Really Great Conversations.” Questions range from “would you prefer to spend money for a housekeeper, a cook, a gardener, or a personal secretary?” … Continue reading

Share
Posted in Best Practices, Communicating Data to the Public, Design Basics, Etcetera, Know Your Audience, Newsletters | Leave a comment