Excel Tips & Tricks - 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…

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

Post author:KathyDevSite
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…

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

Post author:KathyDevSite
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…

How to Make a Deviation Graph

Post author:KathyDevSite
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…

How to Make Sparklines in Excel 2007

Post author:KathyDevSite
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…

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…

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: