Editing Charts & Graphs - Katherine S. Rowell

How to Make a Soda Chart

Post author:KathyDevSite
Post published:February 14, 2014
Post category:Editing Charts & Graphs / Excel Tips & Tricks
Post comments:2 Comments

Here's an example of a real-world problem. In a deprived inner city borough of the U.K. with the usual range of problems — drugs, gangs, gun and knife crime, alcohol-fueled…

Variation and Its Discontents

Post author:KathyDevSite
Post published:October 4, 2013
Post category:Communicating Data to the Public / Data Analysis / Design Basics / Editing Charts & Graphs / Graphs
Post comments:1 Comment

Funnel Plots for Fair Comparisons by Stephen Few and Katherine Rowell Central to quantitative data analysis is an understanding of variation. When we measure multiple occurrences of things to determine…

Give Your Y Axis a Break

Post author:KathyDevSite
Post published:August 20, 2013
Post category:Editing Charts & Graphs / Graphs / Newsletters
Post comments:0 Comments

I recently got to glimpse what a jet-setter's life might be like when I went to Niagara Falls, Canada, for less than a day (in and out in about eight…

How to Simulate a “Broken axis” Value Axis

Post author:KathyDevSite
Post published:August 12, 2013
Post category:Editing Charts & Graphs / Excel Tips & Tricks / Graphs
Post comments:6 Comments

This type of chart is often used when a few data points greatly exceed the others. When plotted on a standard chart the other values are dwarfed. The chart actually…

How to Make a Gantt Chart for Repeated Tasks

Post author:KathyDevSite
Post published:May 16, 2013
Post category:Editing Charts & Graphs / Excel Tips & Tricks
Post comments:23 Comments

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…

How to Make a Gantt Chart

Post author:KathyDevSite
Post published:May 16, 2013
Post category:Editing Charts & Graphs / Excel Tips & Tricks
Post comments:1 Comment

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…

How to Make a Table Lens

Post author:KathyDevSite
Post published:March 4, 2013
Post category:Editing Charts & Graphs / Excel Tips & Tricks
Post comments:2 Comments

A table lens display provides a way to view potential correlations between several quantitative variables simultaneously. Step 1. Enter the labels for the data set in column A. See attached…

How to Make a Dot Plot

Post author:KathyDevSite
Post published:December 7, 2012
Post category:Editing Charts & Graphs / Excel Tips & Tricks
Post comments:7 Comments

A Dot Plot is a graphing utility showing the frequency of different pieces of data in a set. It is extremely effective for showing categorical data. Dot plots can be…

How to Make a Histogram

Post author:KathyDevSite
Post published:November 8, 2012
Post category:Editing Charts & Graphs / Excel Tips & Tricks
Post comments:2 Comments

A histogram is a distribution graph that allows you to see how several measurements fall within set ranges, or bins, of the dependent variable. A histogram is usually depicted as…

Editing the Data

Post author:KathyDevSite
Post published:October 12, 2012
Post category:Editing Charts & Graphs
Post comments:0 Comments

Data for example: The values in a chart are linked to the worksheet data from which the chart is created. To make changes to the data plotted in the existing…

Welcome to my newsletter and blog, Health and Healthcare Data Unleashed, a guide to understanding, presenting and using health and healthcare data, information and evidence. I’ve been writing and posting here since 2010 on a range of topics and resources I’ve encountered in my own data analysis and data visualization journey. You will notice a gap beginning in 2020 as I took time away to work on my book, Visualizing Health and Healthcare Data – I hope you’ll check it out!

Sign up for my email newsletter:

Unleash Your Inner Healthcare Data

Connect with Kathy:

Sign up for my email newsletter: