Prev: Filtering data for scatter plot with chart labels
Next: Anti-alising in copied charts
From: Eric on 23 Jun 2008 15:15
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
From: Andy Pope on 23 Jun 2008 15:59
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
From: Eric on 23 Jun 2008 16:43
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
>
 | 
Pages: 1
Prev: Filtering data for scatter plot with chart labels
Next: Anti-alising in copied charts