
In this chart, you could use your mouse to zoom in a specific span of the time to view detail numbers. I used HighCharts.js in this specific example.

Basically, this add-in allows you to use JavaScript directly in Excel so you could make use of libraries like HighCharts.js or D3.js to make interactive charts.

I made this chart with the Funfun Excel add-in. The pic below shows you the example that I made based on your description. While other answers pointed out how you could make a chart in Excel alone, here I propose another solution that could make an interactive line chart that addresses the problems that I mentioned. I noticed that in your sample data, you actually have a relatively large time span with irregular time intervals.
