Quote Originally Posted by Glenn Kennedy View Post
This is NOT going to work. You are expecting too much from Excel. With 30,000 rows of raw data it is going to crash. INEVITABLY. EVERY TIME. It will SIMPLY NOT WORK the way you want it to.

This is my LAST offer to you.

1. Calculate the regression formula for all days, over a range of 25,000 rows using a formula. Even this might be IMPOSSIBLY slow.

2. Using a dropdown box, select an individual day. The filtered data and graph will populate. If you want to see another day, select another day from the dropdown. With up to 1500 rows of data coming from 25000 rows of raw data, each time you change the date chosen, there will be about a one minute wait.

If that is not acceptable to you - then you are on your own.
In this case, can you please provide separate sheet for filter data