• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Rolling 13 wks data not working but rolling header working

    I will check for the spaces. Thanks anyways. Hopefully it works this time.
  2. A

    Rolling 13 wks data not working but rolling header working

    The columns in B1:DH also have the format as wk01, wk02,etc...but is derived through a formula.
  3. A

    Rolling 13 wks data not working but rolling header working

    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?
  4. A

    Rolling 13 wks data not working but rolling header working

    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...
  5. A

    Flexible charts - Urgent

    Sorry about that. I usually do that to have people reply to me faster..:) I will try and see if your solution works. Thanks for your prompt reply.
  6. A

    Flexible charts - Urgent

    Where do i find the Camera Tool? Should i go to Paint?
  7. A

    Flexible charts - Urgent

    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?
  8. A

    Flexible charts - Urgent

    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...
Back
Top