Instead of showing all the data in a chart, you can select a specific date range, and show only the data from that period. In this example, drop down lists of dates are created with data validation. Select a start and end date, and the chart changes to show the new range.

To create [...]