Sum and chart in excel
- by Chris Lively
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
