How do I make an interactive chart

Is there a simpler way to make the charts in the attached workbook interactive?
How about without using macros?

It maybe possible to make it interactive by using Named ranges.

You could add 2 data validation lists that allow the user to select either a date or date range.
This information would be used to locate start and end rows within your data.

There are examples of dynamic named range charts on the forum.

Post back if you get stuck.

You can use the Search just as easily as me.
The keywords are,
dynamic named range charts

Here is a link to an external source on interactive charts
http://peltiertech.com/Excel/Charts/Dynamics.html