darinspence
New Member
- Joined
- Mar 10, 2004
- Messages
- 9
I've got a sheet with Weeks in the x-axis and products in the y-axis (1-52).
I'd like to create an interactive chart. There are two things I'd like to accomplish.
1) I'd like to just "click" the name of the product, then go to the chart tab and see ONLY the "sales" for that product.
2) I'd like to dynamically "set the range" be able to "pull" the current date weeknum(now()), subtract 3 (weeks) and have that be the beginning of the range. The end of the range would be the current week plus 6.
In all, I'd have a 9-week period that'd I'd be reviewing sales volume for the product that I've "clicked" on in the data sheet. I'd be cool with doing this with a drop-down menu, but there's about 140 products to scroll through.
What do you think...is something like this possible? I'm no VB dude, maybe there's some add-in's or macros that help?
Thank you SO much for any input or help.
--Darin
I'd like to create an interactive chart. There are two things I'd like to accomplish.
1) I'd like to just "click" the name of the product, then go to the chart tab and see ONLY the "sales" for that product.
2) I'd like to dynamically "set the range" be able to "pull" the current date weeknum(now()), subtract 3 (weeks) and have that be the beginning of the range. The end of the range would be the current week plus 6.
In all, I'd have a 9-week period that'd I'd be reviewing sales volume for the product that I've "clicked" on in the data sheet. I'd be cool with doing this with a drop-down menu, but there's about 140 products to scroll through.
What do you think...is something like this possible? I'm no VB dude, maybe there's some add-in's or macros that help?
Thank you SO much for any input or help.
--Darin