grouping Data for charts

E

Eric

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
 
A

Andy Pope

Hi,

Charts do not summarize data. You have to do that using formula or pivot
tables. Then you chart the results.

The SUMIF formula should work for your data.

Cheers
Andy
 
E

Eric

Thanks Andy, I'll give those a try.

Andy Pope said:
Hi,

Charts do not summarize data. You have to do that using formula or pivot
tables. Then you chart the results.

The SUMIF formula should work for your data.

Cheers
Andy
 
Top