by Nate Moore | Nov 15, 2010 | Charts
Excel Video 110 helps you enter data and a Sparkline in the same cell. In the past few videos, we’ve put data and Sparklines in separate cells. Depending on your dashboard or report, you may want to put data in the same cell as the Sparklines. Sometimes combining both...
by Nate Moore | Nov 10, 2010 | Charts
Excel Video 109 covers two topics, how to group Sparklines and the options for the Sparklines’ vertical axis. There are a couple of ways to put Sparklines in a group. If you create one Sparkline and then copy it down, Excel puts all of the Sparklines in a group. If...
by Nate Moore | Nov 8, 2010 | Charts
Excel Video 108 walks through the process of creating a Sparkline. Notice how it’s fairly easy to create a new Sparkline from the Insert tab and how it’s even easier to copy a Sparkline to a range of cells. Excel will correctly reference the cell range for each...
by Nate Moore | Nov 3, 2010 | Charts
Excel Video 107 introduces Sparklines, a new feature in Excel 2010. Sparklines are small charts that fit in one cell. You don’t have nearly as many options as you do with a regular chart, but Sparklines are a great way to display data in a very small space. There are...
by Nate Moore | Nov 1, 2010 | Charts
Excel Video 106 reviews Error Bars and shows how to use custom Error Bars to show more data on the same chart. Hats off for the idea in this video to John Walkenbach, whose book on Excel 2007 Charts has given me several good charting ideas. Typically Excel uses Error...
by Nate Moore | Oct 27, 2010 | Charts
Excel Video 105 showcases clinical data instead of the financial data we’ve spent time charting in prior videos. More and more, the ability to track clinical data in a dashboard will be critical to a practice’s success. Besides applying our charting tricks to clinical...
