I have an excel 10 spreadsheet that I add data to 5 days a week.
I use the 30 last data points to create a chart.
Currently I have to change all points on the chart every time I add to keep a rolling 30 day chart.
Is there a way to set up a filter or some other means to automatically use the...