by Nate Moore | Dec 8, 2010 | Charts
Excel Video 116 walks through the steps to create a thermometer chart. Thermometers don’t show trends, but are a good visual way to track a single variable, like progressing toward a goal. This video went a little longer than most Excel Videos since I tried to show...
by Nate Moore | Dec 6, 2010 | Charts
Excel Video 115 adds some formatting tricks around the Sparkline to make it look more like a small chart. Sometimes you’ll want a dashboard to have something bigger than a Sparkline but smaller than a chart. Watch Excel Video 115 to get some ideas on how to make a...
by Nate Moore | Dec 1, 2010 | Charts
Excel Video 114 uses a new example to review the variety ways to highlight Sparklines with markers. Excel makes it easy to highlight the high and low points, negative points, and the first and last points in a Sparkline. It’s also easy to change the color of the...
by Nate Moore | Nov 29, 2010 | Charts
Excel Video 113 adds a hyperlink to our dashboard. Adding a hyperlink’s not too hard, but it is usually one of the last things I do, since once I add the hyperlink, any time I click on the area to change something I follow the hyperlink instead. The trick to adding a...
by Nate Moore | Nov 22, 2010 | Charts
In Excel Video 112 we’ll go step-by-step through the process of setting up one of the diagnosis dashboard groups from the last video. Once we have one dashboard group set up, it’s faster and easier to simply copy an existing dashboard group and change the references....
by Nate Moore | Nov 17, 2010 | Charts
Excel Video 111 introduces a dashboard you could make with Sparklines in Excel. In this video I’ll walk through the components of the dashboard. Stay tuned for future Excel Videos where I’ll go through the steps to create the dashboard. Notice how each diagnosis code...
