![creating a drop down calendar in excel creating a drop down calendar in excel](https://wmfexcel.files.wordpress.com/2013/11/excel-tips-14-2-more-controls-list.png)
Click OK, then repeat these steps to create a dropdown for the End Date.ĭefine the named ranges for X and Y values:.
![creating a drop down calendar in excel creating a drop down calendar in excel](https://www.vertex42.com/blog/wp-content/uploads/Gantt-Chart-new-version-2-3-1.gif)
On the Ribbon, click the Data tab, then click Data Validation.Click in the Refers To box, and select the Chart Dates (A2:A23) on the worksheet.īecause this range is in an Excel Table, the reference will automatically change to show theĬreate the Start Date and End Date dropdowns.Type ChartDates as the name for the range.On the Ribbon, click the Formulas tab, then click Define Name.[ Note: Because you did not create an Excel Table, as advised above, use the following formula in step 3, to create a dynamic range for the ChartDates: Select the End Date cell I17, and in the Name Box type EndDate, then press Enter.In the Name box, type StartDate then press Enter, to name the cell.On the Chart sheet, select the Start Date cell (F17).In the Create Table dialog box, click OK, to create the table for the selected range.On the Ribbon, click the Insert tab, then click Table.On the Chart sheet, select a cell in the chart data, e.g.To create this dynamic chart in Excel 2007, you can create a table from the chart data, then create named ranges, and use those names in the chart. Select Excel chart dates from a drop down list, and the chart changes to show the new range.
![creating a drop down calendar in excel creating a drop down calendar in excel](https://danielcurran.com/wp-content/uploads/2009/02/Excel-Large.jpg)
In this example, drop down lists of dates are created with data validation. Instead of showing all the data in a chart, you can select a specific date range, and show only the data from that period.