by Nate Moore | Jan 3, 2011 | Charts
Excel Video 119 builds the outside ring of the speedometer chart. The trick to getting the outside of the speedometer chart to work is to select a doughnut chart as the chart type and then change the colors and rotate the doughnut. I’ll show you two different ways to...
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...
