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....
by Nate Moore | Aug 23, 2010 | Charts
Excel Video 86 walks you through two of the three steps to use OFFSET to automatically update charts as we discussed in Excel Video 85. You’ll remember Excel Video 85 explained the need to use OFFSET, define a name, and use that name as the chart’s data source for a...
by Nate Moore | Aug 18, 2010 | Charts
Excel Video 85 starts our discussion of OFFSET, a powerful Excel function you can use to update your charts automatically. If you’ve missed some of the basics of charting videos because you’re familiar with charts in Excel, it’s time to start watching again. We’re...
