Advanced Tricks to Automate Chart Ranges Playlist

Excel Video 83 Adding Contiguous Data to a Chart Manually and Automatically

Excel Video 83 demonstrates two methods to add contiguous data to a chart. Contiguous simply means that the...

Excel Video 84 Adding Noncontiguous Data to a Chart

Excel Video 84 shows you two ways to add noncontiguous data to a chart. Noncontiguous data is data that...

Excel Video 85 starts our discussion of OFFSET, a powerful Excel function you can use to update your charts...

Excel Video 86 walks you through two of the three steps to use OFFSET to automatically update charts as we...

Excel Video 87 is our first take at the OFFSET function in Excel. Understanding how OFFSET works is critical...

Excel Video 89 takes our discussion of automatically updating charts using OFFSET three steps further. ...

Excel Video 90 takes a quick break from OFFSET to show you how to create a drop-down box like the one in...

Excel Video 91 starts to showcase the power of what OFFSET can do for your charts. Now that we’re more...

Excel Video 92 continues our discussion about using OFFSET to make interactive charts. There are two things...

Excel Video 93 gets even fancier by adding a scroll bar right above the chart that automatically controls the...

Excel Video 94 continues our discussion of whiz-bang ways to update your chart ranges. Last time we added a...

Excel Video 95 demonstrates how to use check boxes inside a group box to allow users to choose which data to...

Excel Video 96 picks up where we left off in Excel Video 95. First, notice how changing the background color...