by Nate Moore | Jan 31, 2011 | Charts
Excel Video 127 explodes a pie chart. In Excel-speak, exploding a slice (or more) of a pie chart is a way to separate the slice(s) from the main pie. You can control how far away from the pie that slices explode to get just the effect and emphasis you need. There’s...
by Nate Moore | Jan 26, 2011 | Charts
Excel Video 126 is a quick look at two ways you can help users quickly focus on the critical information in a chart and draw appropriate conclusions. Today’s chart shows the year-to-date percentage of block time used by a practice. Let’s look at two ways to emphasize...
by Nate Moore | Jan 24, 2011 | Charts
Excel Video 125 shows you how to replace the standard chart colors with a picture from your clipboard. The next time you want your physicians to really notice a chart, replace the standard fill colors with a picture. When you chart with a picture, it may be harder to...
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...
