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...
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...
