Solved

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

Posted on 2010-08-21
3
379 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:BrianEsser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 33494102
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
 

Author Closing Comment

by:BrianEsser
ID: 33494157
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
 
LVL 50
ID: 33494350
Glad to help. Thanks for the grade!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question