Dynamic HTML KPI Dashboard

I need a single-page HTML dashboard that springs to life the moment I upload a fresh Excel workbook. The sheet will hold Process-Safety KPI data; once it is dropped into the page, the code should parse it in-browser (no server component), render bar charts and line graphs, and let me narrow all visuals with a simple date or month range selector.

While viewing the charts I want basic interactivity: hovering reveals tooltips and clicking a data point highlights the underlying record or series. Smooth, fast, and intuitive is the goal.

Core expectations
• A clean HTML file with embedded JavaScript—Chart.js, D3, Plotly or any comparable library is fine as long as it remains lightweight and open-source.
• An Excel template that matches the parser so I can keep feeding new data without touching the code.
• The date-range filter should instantly redraw both bar and line visuals when adjusted.
• All assets must work locally from a double-click; no external server or database.

Hand-off items
1. Final HTML dashboard ready for drop-in use
2. Sample / template Excel workbook used in your tests
3. Brief read-me so I can tweak labels or colour palettes later

If the above fits your skill set, let’s lock in the timeline and get this dashboard running.