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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top