not sure that I understand this but if you want to say show only show bars for week 1 to week 5 (because this week is week 5) then show bars for week 1 to week 6 next week, I have done this by setting the graph to named ranges and increasing the range automatically each week.
If this is what you need I will send a worked example
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.