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. 
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.
0 kommentar(er)
