by Nate Moore | Feb 7, 2011 | Charts
Excel Video 129 uses the frequency function to group data into ranges or buckets. Frequency is an array function. If you haven’t seen arrays, they work differently than traditional Excel functions. To tell Excel you’re entering an array formula, you need to hit...
by Nate Moore | Feb 2, 2011 | Charts
Excel Video 128 introduces Pie of Pie Charts. A Pie of Pie Chart is simply a pie chart with a secondary pie chart that shows the detail of a portion of the primary pie chart. Often you’ll have data where a couple of categories make up most of the total followed by a...
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...
