How to get Excel to play nice?
July 4, 2014 6:33 AM Subscribe
I am trying to generate an excel graph that will give me a date/time overview, and I can't quite crack how to set up my table and chart :( Any help will be greatly appreciated.
posted by alchemist to Computers & Internet (6 answers total)
I am trying to get an overview of a trend within our IT network, or even to see whether or not any trend exists. I have 6 servers, and every once in a while *something* happens. We keep logs of date&time that this did happen, but because of the MASSIVE input of data (multiple gigs per hour) we do not keep verbose logs. I am trying to plan for a short window when we do turn on verbose logging, so i'd like to see if there is a trend in when the event happens.
So, how to generate a graph that will show a trend of 6 servers when you have date & time? Do you map this out for each server at a time and then try to overlay? what should my axis be? which chart would be the correct one to use?
Ideally I could look at this/these graph(s) and say "hmmm, OK, there's a good likelihood that if we have verbose logging from 8-9am we can catch this pesky bug".
Thank you in advance for any help and suggestions :)