Populating a table with ranges specified in cells

[Dannyss]

Hi all. This is my first post I hope someone can help. I am creating a dashboard at the moment, meant for multiple users ranging in excel experience levels. There are various background tables feeding this; one of which contains 25 years worth of comparative pricing data for two products. Where I am stuck is that I would like to create a table that will allow the users to select a start and end date and automatically populate a line graph with the data for that date range. I am happy with the use of Formula however VBA is new to me so may need assistance if that is required. Hopefully there is help at hand

 

[cyrilbrd]

Hi, wouldn't a pivot table work for this?
if you need a dynamic chart you just need to create a table that will fetch the data from the specific period of time, any change will be resulted in a chart change equivalent to the data... right? What part holds difficulties?