
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 Automatically Updating Charts with OFFSET
Excel Video 85 starts our discussion of OFFSET, a powerful Excel function you can use to update your charts...
Excel Video 86 Creating and Using Names in Charts
Excel Video 86 walks you through two of the three steps to use OFFSET to automatically update charts as we...
Excel Video 87 Getting Started with OFFSET
Excel Video 87 is our first take at the OFFSET function in Excel. Understanding how OFFSET works is critical...
Excel Video 89 Multiple OFFSETs and COUNTA
Excel Video 89 takes our discussion of automatically updating charts using OFFSET three steps further. ...
Excel Video 90 Get a Drop-Down Box Without Programming
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 Using OFFSET to Create Interactive Charts
Excel Video 91 starts to showcase the power of what OFFSET can do for your charts. Now that we’re more...
Excel Video 92 Using OFFSET with Bigger Ranges
Excel Video 92 continues our discussion about using OFFSET to make interactive charts. There are two things...
Excel Video 93 Adding A Scroll Bar to Control Your Chart Range
Excel Video 93 gets even fancier by adding a scroll bar right above the chart that automatically controls the...
Excel Video 94 Controlling Your Chart Range With a Spin Button
Excel Video 94 continues our discussion of whiz-bang ways to update your chart ranges. Last time we added a...
Excel Video 95 Check Boxes and Group Boxes
Excel Video 95 demonstrates how to use check boxes inside a group box to allow users to choose which data to...