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...
by Nate Moore | Sep 1, 2010 | Charts
Excel Video 89 takes our discussion of automatically updating charts using OFFSET three steps further. We’ll start by looking at the chart from Excel Video 88. Note that the numbers in row 2 are set up with OFFSET so as we add more data, the numbers part of the chart...
by Nate Moore | Aug 30, 2010 | Charts
Excel Video 88 continues our discussion of OFFSET. Instead of having our data in rows (so OFFSET’s height is variable and the width is 1), the data is in columns (so OFFSET’s height is 1 and the width is variable.) Just like in the last video, one of the tricks is to...
by Nate Moore | Aug 25, 2010 | Charts
Excel Video 87 is our first take at the OFFSET function in Excel. Understanding how OFFSET works is critical to unlocking powerful, automatically updating charts. We’ll go through a complete example in Excel Video 87 and then do a similar example in Excel Video 88....
