# 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

## 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

## 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

## 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

## 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

## 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

## 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

## 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