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