Currently Being ModeratedDec 28, 2013 3:58 PM (in response to freediverx01)
Use a summary table to collect the seven days of data, and run the charts from there. Place the starting date in the first data cell in column A (usually A2), either directly or using a slider or stepper to retrieve the date from the original data table or a lookup table consisnting of a list of numbers in column A and a corresponding list of dates in column B.
Use =A2+1 to calculate the next date in A3, and fill down to the seventh row requiring a date.
Use VLOOKUP or OFFSET to retrieve the data sets for the seven dates from the original data table.
A more detiled answer can be supplied after seeing your screen shots, which are not showing up here.
Currently Being ModeratedDec 28, 2013 4:46 PM (in response to Barry)
Currently Being ModeratedDec 28, 2013 6:31 PM (in response to freediverx01)
Data is the original data table.
Set Start is a four cell table with A2 set as a Slider, range 1 - 100, and the formula below in B2:
B2: =OFFSET(Data :: $A$1,A,0)
Cell B2 is for display only. It offers live feedback to the user while setting the beginning date for the chart, but is not used in the calculations in For Chart.
For Chart is a Summary table containing the headers shown.
There is one formula in this table, entered in A2, then filled right to D2, and down to row 8:
A2: =OFFSET(Data :: $A$1,ROW()-2+Set Start :: $A$2,COLUMN()-1)
The chart draws its information from For Chart. Here is a second chart image using the same data table. The only change is that the user has reset the slider to a larger value. The start date on this chart is the same as the last date on the one above.