I have a bar graph that shows revenue by week, for week 1 thru week
52. Each week the graph pulls in the current week results. Is there
a way to have the graph only show results for week 1 thru the current
week, without me having to adjust the data source range each week.

Also, I have a bar graph that shows year-to-date revenue that is
updated each week. Is there a way that the scale can be automatically
updated to fit the data, without me having to manually adjust each
week.