Vulnerability Prediction Tool

I'm working on a project that will track up to 50 events (by date & time as
they happen...the only two sole pieces of data entered) and will calculate
the average duration between events to project future events (through
averages). My problem is being able to display that information visually in
a chart (X-axis by hour in a 24-hour clock, and Y-axis by dates). I'm trying
to get the chart to show both past events, as well as illustrate the next
predicted event time (time of vulnerability), but future ones as well. I
might be asking to much of excel in graphic visualizations thorugh the use of
a chart. The function and calculations are pretty simple and straight
forward. I'm just a novice in making charts do more than pies.

Thank you for any assistance you may be able to provide