Dynamic Chart with start date and end date

Hello,

I need some help with the creation of a dynamic Excel chart that links automatically to a selected start date and a selected end date.

There are 2 worksheets : one with the data (tab name Data) and another with the standard Excel Open-High-Low-Close chart (tab name Chart) that includes a cell for entering start date and end date. So based on the start date and end date selection, the chart will only display the data (open/high/low/close) between these 2 dates.

I have created the named ranges for Dates, Select End date as well as Data columns ( open, high, low, close ) but I am unable to accomplish the last step which is to link these ranges to the chart. I have enclosed a sample workbook and will greatly appreciate any help to make the chart dynamic as described above.

Thank you !

engine44

Thank you very much for the updated sample doc. This is exactly what I need !