by Nate Moore | Jan 19, 2011 | Charts
Excel Video 124 demonstrates how to add a second y axis to a chart. In this example, we’re charting collection dollars and the percent of billed charges on the same chart. The collections each month are hundreds of thousands of dollars while the percentage of billed...
by Nate Moore | Jan 17, 2011 | Charts
Excel Video 123 introduces the idea of putting different types of chart series on the same chart. Today we’ll add two line series to a column chart. To add the series, I simply copied the data and pasted it into my chart. Once the data’s in the chart, I right-clicked...
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...
