by Nate Moore | Dec 15, 2010 | Charts
Excel Video 118 is designed to set up the data entry for our speedometer chart. The key to understanding the structure of the data is to recognize that we’re plotting the data on circular charts and will hide the bottom half of the chart later on. That means we’re...
by Nate Moore | Dec 13, 2010 | Charts
Excel Video 117 introduces speedometer charts in Excel. Speedometer charts, like the thermometer charts we looked at last time, are a visual way to represent one variable in Excel. Speedometer charts tend to take up a fair amount of space in a dashboard, but they can...
by Nate Moore | Dec 8, 2010 | Charts
Excel Video 116 walks through the steps to create a thermometer chart. Thermometers don’t show trends, but are a good visual way to track a single variable, like progressing toward a goal. This video went a little longer than most Excel Videos since I tried to show...
by Nate Moore | Dec 6, 2010 | Charts
Excel Video 115 adds some formatting tricks around the Sparkline to make it look more like a small chart. Sometimes you’ll want a dashboard to have something bigger than a Sparkline but smaller than a chart. Watch Excel Video 115 to get some ideas on how to make a...
by Nate Moore | Dec 1, 2010 | Charts
Excel Video 114 uses a new example to review the variety ways to highlight Sparklines with markers. Excel makes it easy to highlight the high and low points, negative points, and the first and last points in a Sparkline. It’s also easy to change the color of the...
