vendredi 27 mars 2015

Calculate Sum of Several Rows and Create Bar Graph Excel

I have a large set of values: ID HOURS 29 9

29 9

29 8

29 9

29 10

29 9

29 9

29 7

29 9

29 9

29 8

29 10

29 8

29 9

29 9

29 8

29 9

29 10

29 9

29 9

29 8

29 6

29 9

29 9

29 6

29 9

29 8

29 9

29 9

29 8

29 9

29 9

29 8

29 9

29 9

29 9

29 8

29 10

29 9

29 7

29 10

29 8.5

29 8.5

29 7.5

29 7

29 6

29 9

29 8.5

29 10

29 9

29 8.5

29 9

29 9

29 8

29 8.5

29 8

29 9

29 8.5

29 8.5

29 10

29 8

29 7.5

29 7.5

29 7.5

29 9

29 7.5

29 9

29 10

29 10

29 8.5

29 7.5

29 8

29 8.5

29 9.5

29 7

29 9.5

29 9

29 8.5

29 8.5

29 7.5

29 8

29 8

29 8.5

29 9

29 8.5

29 9

29 9

29 8.5

29 9

29 10

29 9

29 8.5

29 9

29 7

29 9

28 7

28 8

28 9

28 8

28 7

28 9

28 9

28 9

28 8

28 9

28 9

28 8

28 9

28 9

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


Aucun commentaire:

Enregistrer un commentaire