I have an excel table similar to what is below but much larger. My question
is: I would, for instance, like to graph the total number of items at each
of the 4 "locations". When i try to graph this, I get totals as if each
entry is it's own location. Can anyone tell me if I group the locations
together when graphing?

Location Items
1 52
1 36
2 72
1 59
3 85
2 102
3 12
1 96
1 23
4 35
4 44
3 66
1 89
2 75
2 54

Thanks,
-Eric