We need to display graphs which are rolling-13 weeks. We have been able to get the week numbers to roll. The data is on the same sheet on the left hand side - columns BI to DH). The charts' source data that we are going to make flexible (13-wk rolling) is towards the right end of the sheet (cols...
I have a dropdown which has these options - Group Total, Group Breakup, Member1, Member2, Member3. As you select options in the dropdown, the corresponding data will change. This works fine. Now, my problem begins here. I also have some charts which will change based on the data that is there...