grouping Data for charts
 

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

grouping Data for charts
 

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

Eric wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

grouping Data for charts
 

Thanks Andy, I'll give those a try.

"Andy Pope" wrote:

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

Eric wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info