A calendar is a common component found in dashboards if a user is interested in seeing values on a particular day. This is great for going back in history to see past performance.
In this example, we will work with one month of data for September 2010, and the chart will change according to what the user selects on the calendar.
The portion of the spreadsheet containing the chart data will need to be set up in the following fashion. Each row of chart data will belong to a selectable day in the calendar. In this example, each row contains region sales data for a particular date.