1 of 1 people found this helpful
Opened your attached workbook - I changed the column pill of week(date) to continuous so I could edit the axis. I had a fixed start and end date (0 and 18) which appears to keep all weeks visible, regardless of filter selection (Bunnies, kittens, puppies). Not sure if this helps.
This is very helpful, Jason.
Since this worksheet will be updated each week, is it possible to link the fixed end to a variable? In other words, show the weeks 1--> the maximum number of weeks?
If there's no way to crack this nut, I can set it at 52 and just let it unfold over the year...
Many thanks! This is exactly what I was looking for!