Excel Video 86 Creating and Using Names in Charts from offset excel examples Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Description: 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 chart to automatically update.OFFSET is the most complicated of the three steps, so we’ll review defining a name in Name Manager and changing the chart’s data source in this video and work through the OFFSET function next
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)