Drop down menu in chart and update data if the date change

[montu_seshil]

hi all

struggling since few days to get this right. so now last option to ask for your expertise.

i have a chart, need to bring drop down menu of date and and whatever date i select the data needs to be updated accordingly.

any help ???? i have a file but could not find how to attach here.

thank you
seshil.

---

 

[tmmellor1981]

without a sample difficult for anyone to answer. I've done something similar where I have a drop down box (data validation of dates in a list) and then a formula that then takes 1 day or 1 month off (=DATE(YEAR(O3),MONTH(O3)-1,DAY(O3))), I then use lookups etc to bring me back the data against those dates. Once graph is sourced to the data when you change a date for the dropdown the graph also changes. Hope that kinda makes sense.

 

[Jon Peltier]

I suspect you may benefit from reading my tutorial Chart Partial Range Between Variable Endpoints.

 

[montu_seshil]

thanks all... i have sort of managed to get what i want but not satisfied as i think there should be some simplified way.
can someone tell how to attach s/sheet here ? so i can upload a sample ?

 

[Jon Peltier]

Well, Excel can't do something just because you're thinking it might be nice. You have to do a little setup.