Yearly Archives: 2012

Miracle Weight-Loss Plan: Mabel, Mabel Read the Label!

I recently heard about a study that found that people who read and study nutritional food labels weigh, on average, about nine pounds less than people who don’t. Suffice it to say that I have purchased an extra set of … Continue reading

Posted in Etcetera, In the News, Newsletters | Leave a comment

Stale Donut (Charts)

The other day, I was looking over some reports I’d received from a new client when I came across a doughnut chart. Suddenly, for some inexplicable reason — and to no one in particular — I heard myself quoting Homer … Continue reading

Posted in Best Practices, Design Basics, Graphs, Newsletters | Leave a comment

How to Make a Dot Plot

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 used for any situation for which a bar chart is … Continue reading

Posted in Editing Charts & Graphs, Excel Tips & Tricks | 7 Comments

A Revealing Look at Re-admission Rates

I was whining apologetically to my friend Cindy the other day about being stuck in New Orleans because of Hurricane Sandy. You know — it was the type of whining that’s immediately followed by an apology if you’re hedging your … Continue reading

Posted in Data Analysis, Decision Support, Newsletters | Leave a comment

How to Make a Histogram

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 a bar chart, with one bar representing the count of … Continue reading

Posted in Editing Charts & Graphs, Excel Tips & Tricks | 2 Comments

Pumpkin Wars and Hospital Ratings

Last weekend my husband, Bret, and I traveled to Keene, New Hampshire, to visit our daughter, Annie, who is serving with AmeriCorps|Vista at a school near the town, and to participate in Keene’s Annual Pumpkin Fest. I was looking forward … Continue reading

Posted in Communicating Data to the Public, Data Analysis, Decision Support, Know Your Audience, Newsletters, Point of View | Leave a comment

Editing the Data

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 chart: Go to the worksheet that contains the data that … Continue reading

Posted in Editing Charts & Graphs | Leave a comment

Editing or Adding a Data Series to a Chart

Data for example: Click the chart to which you want to add another data series. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Select Data. In the … Continue reading

Posted in Editing Charts & Graphs | Leave a comment

Editing the Order of the Data Series

Data for example: Click the chart that contains the data series that you want to change. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Select Data. In … Continue reading

Posted in Editing Charts & Graphs | Leave a comment

Editing or Adding a Title

Click anywhere on the chart. On the Chart Tools Layout tab, click the Chart Title button in the Labels group. A list of options appears: None: This choice means you don’t want to display a title. Also use this option … Continue reading

Posted in Editing Charts & Graphs | Leave a comment