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. …