Select Page

Excel Video 113 Creating a Sparkline Dashboard Part 3

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

Excel Video 112 Creating a Sparkline Dashboard Part 2

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

Excel Video 111 Creating a Sparkline Dashboard Part 1

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

Excel Video 110 Sparklines with Text

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

Excel Video 109 Sparkline Groups

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