title: Calculate Sum of Several Rows and Create Bar Graph Excel
body: <p>I have a large set of values:
  ID HOURS
  29  9<br>
  29  9<br>
  29  8<br>
  29  9<br>
  29  10<br>
  29  9<br>
  29  9<br>
  29  7<br>
  29  9<br>
  29  9<br>
  29  8<br>
  29  10<br>
  29  8<br>
  29  9<br>
  29  9<br>
  29  8<br>
  29  9<br>
  29  10<br>
  29  9<br>
  29  9<br>
  29  8<br>
  29  6<br>
  29  9<br>
  29  9<br>
  29  6<br>
  29  9<br>
  29  8<br>
  29  9<br>
  29  9<br>
  29  8<br>
  29  9<br>
  29  9<br>
  29  8<br>
  29  9<br>
  29  9<br>
  29  9<br>
  29  8<br>
  29  10<br>
  29  9<br>
  29  7<br>
  29  10<br>
  29  8.5<br>
  29  8.5<br>
  29  7.5<br>
  29  7<br>
  29  6<br>
  29  9<br>
  29  8.5<br>
  29  10<br>
  29  9<br>
  29  8.5<br>
  29  9<br>
  29  9<br>
  29  8<br>
  29  8.5<br>
  29  8<br>
  29  9<br>
  29  8.5<br>
  29  8.5<br>
  29  10<br>
  29  8<br>
  29  7.5<br>
  29  7.5<br>
  29  7.5<br>
  29  9<br>
  29  7.5<br>
  29  9<br>
  29  10<br>
  29  10<br>
  29  8.5<br>
  29  7.5<br>
  29  8<br>
  29  8.5<br>
  29  9.5<br>
  29  7<br>
  29  9.5<br>
  29  9<br>
  29  8.5<br>
  29  8.5<br>
  29  7.5<br>
  29  8<br>
  29  8<br>
  29  8.5<br>
  29  9<br>
  29  8.5<br>
  29  9<br>
  29  9<br>
  29  8.5<br>
  29  9<br>
  29  10<br>
  29  9<br>
  29  8.5<br>
  29  9<br>
  29  7<br>
  29  9<br>
  28  7<br>
  28  8<br>
  28  9<br>
  28  8<br>
  28  7<br>
  28  9<br>
  28  9<br>
  28  9<br>
  28  8<br>
  28  9<br>
  28  9<br>
  28  8<br>
  28  9<br>
  28  9<br>
  ... all the way to ID 1
  There is a random number of hours for every ID, and I have to create a bar graph that sums up the values of each ID and displays them in a bar graph. I am very new to excel, how do I do this?</p>