Change graph according to the dates selected

[tinumathews]

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.

 

[fred]

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.

 

[NARAYANK991]

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