by Nate Moore | Sep 20, 2010 | Charts
Excel Video 94 continues our discussion of whiz-bang ways to update your chart ranges. Last time we added a scroll bar to control the chart range. Today, we’ll try spin buttons. Spin buttons are simply an up arrow paired with a down arrow that we’ll use to change the...
by Nate Moore | Sep 15, 2010 | Charts
Excel Video 93 gets even fancier by adding a scroll bar right above the chart that automatically controls the number of columns in the chart. To get the scroll bar and other tools, you need to add the Developer tab to your ribbon. I’ll show you how to add that, and...
by Nate Moore | Sep 13, 2010 | Charts
Excel Video 92 continues our discussion about using OFFSET to make interactive charts. There are two things I’d like to show you in this video. First, notice how that when I change cell G14, the cell I named Include, the title of the chart changes to reflect the...
by Nate Moore | Sep 8, 2010 | Charts
Excel Video 91 starts to showcase the power of what OFFSET can do for your charts. Now that we’re more familiar with OFFSET, we can not only increase the range of the chart to account for more data, we can automatically control the number of columns in the chart by...
by Nate Moore | Sep 6, 2010 | Charts
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 89. Hopefully you saw the drop-down box I created as part of Excel Video 89 to show the components of the OFFSET function for Year, SanDiego, and...
