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

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 Vertical Bullet Chart

  • Post author:Kathy Rowell
  • Post published:June 4, 2013
  • Post category:Excel Tips & Tricks/Graphs
  • Post comments:1 Comment

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…

Continue Reading How to Make a Vertical Bullet Chart

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 Deviation Graph through Time

  • Post author:Kathy Rowell
  • Post published:February 14, 2013
  • Post category:Excel Tips & Tricks/Graphs
  • Post comments:0 Comments

A graph displays a deviation relationship when it features how one or more sets of quantitative values differ from a reference set of values. The graph does this by directly…

Continue Reading How to Make a Deviation Graph through Time

How to Make a Deviation Graph

  • Post author:Kathy Rowell
  • Post published:February 14, 2013
  • Post category:Excel Tips & Tricks/Graphs
  • Post comments:0 Comments

A graph displays a deviation relationship when it features how one or more sets of quantitative values differ from a reference set of values. The graph does this by directly…

Continue Reading How to Make a Deviation Graph

How to Make Sparklines in Excel 2007

  • Post author:Kathy Rowell
  • Post published:January 19, 2013
  • Post category:Excel Tips & Tricks
  • Post comments:11 Comments

A sparkline is a very small line chart that is typically drawn without axes or coordinates. It presents the general shape of the variation (typically over time) in some measurement…

Continue Reading How to Make Sparklines in Excel 2007

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
  • 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.