by Nate Moore | Jan 12, 2011 | Charts
Excel Video 122 uses a trick we learned in speedometers to make a column chart appear to float on the page. Today we’re plotting the range of wait times for a physician clinic. After we have the high and the low wait time for the day plotted on the chart, we’ll add...
by Nate Moore | Jan 10, 2011 | Charts
Excel Video 121 demonstrates some additional things you can do with a speedometer chart. We’re not going to get into all of the details and work through complicated examples, but I do want you to see how you can add an outer dial to a speedometer to show labels like...
by Nate Moore | Jan 5, 2011 | Charts
Excel Video 120 finishes our speedometer by adding the needle. To put the needle on the speedometer, you need to add another data series to the chart. Fortunately, we set up all of the information we needed in Excel Video 117, so we just need to add that data to the...
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...
