Line chart with changing start and end dates

[BWellman]

Hello,

I am looking to make a line chart where the start date and end date are selected by two drop down cells. In the attached document C9 and C10 are drop downs dependent on the dates in the top of the table. Is it possible to have the chart below change to reflect the range of whatever dates are selected in the cells?

If possible, I would like the chart as it is now (it updates the range based on the date) to be the default when no dates are selected.

Thanks,
B

[Kaper]

Probably wrong attachment. Cells C9 and C10 are empty. Chart is empty too.

[BWellman]

Sorry - have attached the updated file.

B

[Kaper]

You had already dynamic chart so I not changed the chart at all. I only changed your name ChtLabels to:

Please Login or Register  to view this content.

and introduced two new names (used in above name) startdate and enddate defined as:

Please Login or Register  to view this content.

So if C9 and C10 are empty chart remains as it is now. If both are filled, it's between these dates, and if only one is filled, it's between that date and final date based on current date (C2)