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: 912

Filed under:

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

Related posts about excel-2010