Yearly Archives: 2012

Editing an Axis

Right click on the horizontal axis and click on Format Axis. In the pop up box Axis Options click on Fixed under Minimum and change the value to 0 and under Maximum click on Fixed change the value to 500. … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment

Editing the Chart Type of an Existing Chart

To change the chart type of the whole chart, click the chart area or plot area of the chart to display the chart tools. On the Design tab, in the Type group, click Change Chart Type. In the Change Chart … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment

Confidence Intervals Required

Here’s what’s driving me crazy today: healthcare outcome and performance reports — especially those that display statistics such as Observed versus Expected (O/E) Mortality Ratios without showing the relevant (and utterly crucial) Confidence Intervals (CI’s). This omission should make you … Continue reading

Share
Posted in Best Practices, Dashboards, Data Analysis, Decision Support, Graphs, Know Your Audience, Newsletters, Risk Adjustment, Statistics (is not a dirty word) | 2 Comments

No Grand Vision

I was recently flipping through yet another design-challenged presentation of healthcare data, and started thinking about a project on the Grand Canyon I’d done when I was in the eighth grade. I’d made a model using colored clay to show … Continue reading

Share
Posted in Design Basics, Newsletters, Point of View | Leave a comment

Mere Mortals and Mortality Data

Many, many moons ago when I was a dating girl, I discovered that there were basically two categories of bad dates. There was the date that I hoped might lead to something more, but that ended with “I’m not ready … Continue reading

Share
Posted in Best Practices, Communicating Data to the Public, Data Analysis, Know Your Audience, Newsletters, Point of View, Risk Adjustment, Statistics (is not a dirty word) | Leave a comment

Making a Small Multiples/Panel Chart

Read more about how the use of small multiples can help you to communicate complex data by using small multiples in my newsletter “Small Multiples — Big Clarity“. Regular Chart Making the Chart Step 1: Create Antibiotics Chart. Select the … Continue reading

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

How to Make a 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 “Bar” and select the first selection under 2-D bar for “Clustered Bar” … Continue reading

Share
Posted in Excel Tips & Tricks | 2 Comments

Labels, Titles and Endorphins, Oh My!

I have been an avowed hater of running since forever. Not wanting to run is just about the only thing in my entire life that I have ever been certain of. That is, until a couple of months ago, when … Continue reading

Share
Posted in Best Practices, Data Analysis, Design Basics, Graphs, Newsletters, Tables | Leave a comment

Reading Room

Resonate Present Visual Stories That Transform Audiences by Nancy Duarte I have been aware of Nancy Duarte’s work for a few years now and I always intended to read her book Resonate but never quite found the time. Well, I … Continue reading

Share
Posted in Books, Newsletters | Leave a comment

Making a Box and Whisker Plot in Excel

Making a Box and Whisker Plot Getting the Data Ready Step 1: Prepare the Data for the Chart. Insert several blank rows to set up range for calculations. This is represented by cells A16 – G24 in the example above. … Continue reading

Share
Posted in Excel Tips & Tricks, Graphs | 33 Comments