Sum and chart in excel
Posted
by
Chris Lively
on Super User
See other posts from Super User
or by Chris Lively
Published on 2012-03-22T23:53:57Z
Indexed on
2012/03/23
5:33 UTC
Read the original article
Hit count: 915
excel-2010
I have data like the following: Both Hour and Count are columns in an excel file.
Hour Count
17 79
18 122
19 123
20 142
21 150
22 78
23 15
13 33
14 33
15 40
16 33
17 56
18 46
19 35
20 67
21 65
22 45
23 36
What I want is to create a chart that shows over a period of 1 to 24 (hours) the total count. What's the easiest way to do this.
The chart should have a horizontal axis that runs from 1 to 24; and a vertical axis that goes from 0 on up.
In the case above the values should be combined like:
1 - 0
2 - 0
3 - 0
4 - 0
5 - 0
6 - 0
7 - 0
8 - 0
9 - 0
10 - 0
11 - 0
12 - 0
13 - 33
14 - 33
15 - 40
16 - 33
17 - 135
18 - 168
19 - 158
20 - 209
21 - 215
22 - 123
23 - 51
24 - 0
© Super User or respective owner