OK. Let me see if I understand. On that first tab, you want the chart to show the data for, say, 9/24 when you enter it into the table above. Right off the top of my head, all you need to do is extend the range of each data series to the right in the Select Data dialog.

Actually, what I want is for B5:B9 to update when I add a new column of data to the dashboard. So tomorrow, when I add in the data for 9/24, I want those numbers to automatically update in the fields I mentioned (B5:B9).