Hi, Last time I visited was 6 years ago! Glad to see it is still a thriving community. Now, to business:
(I have Excel 2010)
Basically, what I am doing is checking (every 5 minutes) the value of three things and I want a graph showing me each
thing's progress (or regress or plateau) during the time I am sampling.
My data looks like this:
Poll Time Name size
1 15:35 one 110
1 15:35 two 500
1 15:35 three 26
2 15:40 one 120
2 15:40 two 500
2 15:40 three 57
3 15:45 one 130
3 15:45 two 500
3 15:45 three 13
"Poll" is the id of each sampling, it is consecutive, starting from 1.
Time is the current time. It is exactly 5 minutes between polls.
One, two and three is a simplification. In reality, they are about 200. I do not want to manually add them.
I tried different things, could not get it. Ideally, the graph I will have will be of
three lines (one, two, three), the Y axis would the the size, the X axis would be
the time (I don't need labels, just to see if there's an incline or decline trend).
Thanks
Bookmarks