Our columns GA to GM are not numbered thru dates but as Wk01, wk02, etc. Also we observed that if the wk number field is a value, hlookup works. If its a formula, it doesnt. Does hlookup work only if the value you are looking up is a value and not a formula?
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...
Thanks for your reply. I checked both the links above. The charts are flexible but just 1 at a time is visible. How can I make 4 visible at one time and then when i change the dropdown, only 1 should be visible?
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...