Link to home
Create AccountLog in
Avatar of amigan_99
amigan_99Flag for United States of America

asked on

Excel: Graphing Count per day

I have a Win event log and I would like to graph how many of these events occur day by day.  What do I need to get such a graph?

8/29/2013 10:29      MSExchangeFDS      1008
8/29/2013 8:17      MSExchange ActiveSync      1008
8/29/2013 2:29      MSExchangeFDS      1008
8/29/2013 0:02      MSExchange ActiveSync      1008
8/29/2013 0:00      MSExchange ActiveSync      1008
8/28/2013 22:50      MSExchange ActiveSync      1008
8/28/2013 20:13      MSExchange ActiveSync      1008
8/28/2013 20:08      MSExchange ActiveSync      1008
8/28/2013 19:26      MSExchange ActiveSync      1008
8/28/2013 18:57      MSExchange ActiveSync      1008
8/28/2013 18:29      MSExchangeFDS      1008
8/28/2013 17:42      MSExchange ActiveSync      1008
8/28/2013 16:57      MSExchange ActiveSync      1008
8/28/2013 16:55      MSExchange ActiveSync      1008
8/28/2013 16:36      MSExchange ActiveSync      1008
8/28/2013 16:31      MSExchange ActiveSync      1008
8/28/2013 13:57      MSExchange ActiveSync      1008
8/28/2013 13:41      MSExchange ActiveSync      1008
Avatar of leptonka
leptonka
Flag of Hungary image

Hi,
Depends on what kind of graph do you prefer.
You can create a support table counting the days, and use a simple line chart. Could be a pivot chart too, depending on your data structure.

Or you can choose a heatmap-kind-of thing, something like:
Day/Hour heatmap

Cheers,
Kris
Avatar of amigan_99

ASKER

A basic bar or line graph X-8/27 Y=15, X=8/28 Y=13, X=8/29 Y=18 etc..
ASKER CERTIFIED SOLUTION
Avatar of kittendh
kittendh
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Great - thank you.