• 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.

Change graph according to the dates selected

T

tinumathews

New Member
Attaching an excel sheet. I need to select the week and the graph should show the changed data. Or there are two buttons placed need to check if that can be done by this button. Dynamic graphs i suppose any help link as given below


https://docs.google.com/spreadsheet/ccc?key=0AsTC4qYnx5-bdDg3SS1NUTFYVWRRSmFzazcwMkFVbEE


Please help.
 
first of all, define the days shown using weeknum(date,1). then you need to do a sum of dates' data in a weekly fashion. Then you can create your graph using weekly data and a pulldown menu as the driver.
 
Hi ,


Can you check out the following link ?


https://skydrive.live.com/view.aspx?cid=754467BA13646A3F&resid=754467BA13646A3F%21135


Change the week in cell F2 , and the X-axis will change accordingly. Cell M1 has been used , column N has been used , and 6 range names have been created.


Is this what you are looking for ?


Narayan
 
You must log in or register to reply here.
Back
Top