Select Date Range for Excel Chart Interactive

Description:
Select start and end dates, and the Microsoft Excel chart changes to show that date range. This technique uses dynamic named ranges, which are based on Excel tables.

This type of interactive date range chart is great for an Excel dashboard, where you need to present key data in a small space.

At the top of the Excel sheet, the chart data's start and end dates are:
--easy to see
--easy to use
--small - only need 4 cells

Also, you could link other dashboards formulas to those start and end cells.

The chart data is custom built, so you can choose key items to include, and omit others.

Also, with this type of data, you can create chart types, like Scatter or Histogram, that aren't available for a pivot chart

Watch this video to see how to set up the interactive Excel chart, and then choose start date and end date..

Get the sample file from my Contextures website:
https://www.contextures.com/xlNames02.html

Or use this short link: myctx.link/ChartDate

Video Timeline
00:00 Introduction
00:21 Sales Data
00:39 Make an Excel Table
01:15 Make Dynamic Range 01
02:56 More Dynamic Ranges
03:31 Date Selection Drop Downs
05:38 Make a Summary
06:05 Summary Formula
08:22 Make a Chart
10:04 Get the Sample File

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1