Skip to content
KS Rowell Logo
  • Welcome
  • Books
  • Workshops + Speaking
  • Consulting
  • Blog – Visualizing Data
Menu
  • Welcome
  • Books
  • Workshops + Speaking
  • Consulting
  • Blog – Visualizing Data

How to Make a Soda Chart

  • Post author:Kathy Rowell
  • 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…

Continue Reading How to Make a Soda Chart

Variation and Its Discontents

  • Post author:Kathy Rowell
  • 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…

Continue Reading Variation and Its Discontents

Give Your Y Axis a Break

  • Post author:Kathy Rowell
  • 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…

Continue Reading Give Your Y Axis a Break

How to Simulate a “Broken axis” Value Axis

  • Post author:Kathy Rowell
  • 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…

Continue Reading How to Simulate a “Broken axis” Value Axis

How to Make a Gantt Chart for Repeated Tasks

  • Post author:Kathy Rowell
  • 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…

Continue Reading How to Make a Gantt Chart for Repeated Tasks

How to Make a Gantt Chart

  • Post author:Kathy Rowell
  • 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…

Continue Reading How to Make a Gantt Chart

How to Make a Table Lens

  • Post author:Kathy Rowell
  • 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…

Continue Reading How to Make a Table Lens

How to Make a Dot Plot

  • Post author:Kathy Rowell
  • 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…

Continue Reading How to Make a Dot Plot

How to Make a Histogram

  • Post author:Kathy Rowell
  • 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…

Continue Reading How to Make a Histogram

Editing the Data

  • Post author:Kathy Rowell
  • 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…

Continue Reading Editing the Data
  • 1
  • 2
  • Go to the next page
Kathy Rowell Blog Visualizing Data

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!

Connect with Kathy:

8 Old Seabury Road
York, ME 03909
617-797-6471
kathy@healthdataviz.com

Linkedin

Sign up for my email newsletter:

Unleash Your Inner Healthcare Data

Select list(s) to subscribe to


By submitting this form, you are consenting to receive marketing emails from: HealthDataViz, 177 Huntington Avenue, Boston, MA, 02115, http://www.healthdataviz.com. You can revoke your consent to receive emails at any time by using the SafeUnsubscribe® link, found at the bottom of every email. Emails are serviced by Constant Contact

Recent Posts

  • Does My MD Look Like Me?
  • Effort Matters
  • Bar Humbug!
  • Heavenly Icons
  • 2019 Reading (and Listening) List for the Health and Healthcare Data Geek

Archives

Categories

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on email
  • Privacy Policy
  • Terms of Use
  • Cookie Policy
  • Design by Time to Task
Copyright © 2021 KS Rowell | All rights reserved
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsAccept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.