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