I am trying to make a chart that will pull the most recent 26 weeks of data
automatically so I won't have to go in and change the range every single
week. I am adding the newest data to the right of the the existing data and
would like to have the chart just to the right of the most recent data.

If you have any suggestions please let me know.

Thanks!

David