Hi everyone,
I have a large amount of weekly team data I would like to show week over week graphically. My data has the week ending dates in column A. I would like to have two Data Validation dropdowns - to select a starting week and an ending week - with the graph being dynamic and changing the X axis to reflect only those weeks selected and those in between. What is a good way of doing this without making it a pivot chart?
Bookmarks