grouping Data for charts

  • Thread starter Thread starter Eric
  • Start date Start date
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
 
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
 
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
 
Back
Top