Hi! I sell at annual events. I have been imputing sales by year into their own sheets. I am wondering if I can create a comparison sheet where I can compare one year to another year, but be able to select which years I would like to compare. Maybe have a drop down menu that would select 2008 and another drop down that would select 2010, or whatever year i'd like. Right now I only have 2 years inputed, but I'd like to add years and be able to switch easily between them in the comparison sheet.
Then I would have a bar graph set up that would compare the 2, sort of like I have it set up right now, but right now there is no way of selecting a different year.
Or maybe there is a better way of doing this all together. Thanks!
test.xlsx
Bookmarks