Graphing/Formatting a Line Chart

Hello All,

I have a set of average handling times data that I am trying to plot on a line graph. I'm trying to see if there is a steady rise or spikes in handling times hourly over a one month period. The problem I'm having is that there are too many data points, and my resulting graph does not seem to look right to me. I'm not sure if it is a formatting issue or I'm not using the correct graph to display the data.

The x-axis are hourly interval dates/time over a month period, and the y-axis hourly average handling.

I have attached a sample wks with my data and the graph I plotted.
Please help, thanks!

Sample Data.xlsx

Regards,
Andy

Originally Posted by Andy Pope

The Date axis for a line chart will only be as accurate as 1 day.

For data points with time you need to change to a xy-scatter chart.

Thank you for the info!