Using Excel - How to best display date and time events in timeline or chart format?

Looking for a solution that would allow me to run a macro that would take the Date and Time of each error and present them is such a way that any patterns would be made more obvious. A Timeline or some sort of Chart I suppose, but I really don't know much about Excel Charts.  I would also like to know the delta time difference between the events in Days, Hours, Minutes. Open to all suggestions and any examples would be welcome.

Thanks,
Brian E
EE-Error-Event-Timeline.xls
Brian EsserZone Technology ExpertAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello Brian E,

you can use an XY Scatter chart for that kind of data. Chart the date values as the X values and the time as the Y values, then format the axes. In the attached example, the Y axis increments are 2 hours. The X axis has a marker ever 14 days. Other options are possible, just say what you need.

I've also put in a few columns to calculate and display the delta. For this to work, I've sorted the data to be ascending, so the oldest date/time is on top.

cheers, teylyn
Copy-of-EE-Error-Event-Timeline.xls
0
 
Brian EsserZone Technology ExpertAuthor Commented:
Excellent! That is exactly what I had hoped for teylyn.
Now to see if I can recreate the same thing based on your example. Great learning exercise now that I know what the possibilities are. Thank you so much.
You folks are truly amazing and together with EE you have provided so many years worth of excellent just-in-time solutions for the community at large - Bravo!
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Glad to help. Thanks for the grade!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.