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

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

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

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

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

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

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

Excel Video 104 covers moving averages, another way to use a trendline in your chart. A moving average is simply an average over the last several periods of data in a chart. We chose to use a three month moving average, so Excel averages the last three months on the...

Excel Video 103 introduces the TREND function to forecast the next three month’s billed charges. Trend is an array function, so instead of getting the formula right in one cell and copying down, you select all of the cells you want the answer in first. The other thing...

Excel Video 102 takes you back to your algebra days to forecast billed charges. Remember y=mx+b, the equation to chart a straight line? That equation will come in handy in Excel Video 102. To forecast billed charges, we’ll use the y=mx+b equation to project future...

Excel Video 101 helps you add a forecast to your chart. Adding the forecast is easy. Figuring out what Excel’s forecast and how Excel calculates that forecast is a little more work. Excel Video 101 is a little longer than the average video because I give you some...

Before we get into the content, I want to thank each of the viewers across the country and in many parts of the world for watching the Excel Videos series at mooresolutionsinc.com. If you watched all of the videos, you’ve spent 6-7 hours and covered a lot of valuable...

Excel Video 99 covers how to adjust your chart to handle gaps in your data, hidden data, and filtered data. If for some reason you’re missing some data that you want to include in your chart, the Hidden and Empty Cells Window (accessed from Select Data Source) allows...

Excel Video 98 shows an easy way to change the order your data is plotted in on a chart. Normally you’ll type data into Excel in the order you want it to appear on a chart. If you’re downloading data from your PM system or some other source, the data may not be in the...

Excel Video 97 is a break from some of the complicated OFFSET examples we’ve been working through. Today I want to show you one tip when you’re charting years and then three ways to modify and/or delete the data in your chart. The tip applies when you have a chart...

Excel Video 96 picks up where we left off in Excel Video 95. First, notice how changing the background color of the check boxes makes the chart look better and allows us to remove the legend, which makes the plot area bigger. It’s also helpful to remove the legend...

Excel Video 95 demonstrates how to use check boxes inside a group box to allow users to choose which data to show on a chart. Our sample data is established patient E&M codes for four physicians and the chart shows the relative percentages of each of the five billing...