Column A: Dates
Example
A1=8/23/2009
A2=9/5/2009
A3=7/29/2009
A4=8/21/2009

Column B: Names
Example
B1=John
B2=John
B3=Jane
B4=John

Column C: Amounts.
C1=$23.52
C2=$14.85
C3=$54.78
C4=$9.84


How can I put this information into a chart and group the amounts into
months. For example, August for John would sum: $$33.36, but for Jane would
sum $0.00

You'll need to produce a summary table, and then use that to drive
your chart (or by "chart" do your really mean "table"?).

List the individual names, eg in E2 down the column. In F1 you can
enter "JUL" (without the quotes), G1 can hold "AUG", H1 can hold "SEP"
etc, then in F2 you can use this formula:

=SUMPRODUCT((TEXT($A$1:$A$20,"mmm")=F$1)*($B$1:$B$ 20=$E2),$C$1:$C$20)

Adjust the ranges to suit (I've assumed 20 rows of data), then copy
across and down as required.

Another way would be to use a pivot table.

Hope this helps.

Pete

On Sep 8, 6:43*pm, GEM wrote:
Column A: Dates
Example
A1=8/23/2009
A2=9/5/2009
A3=7/29/2009
A4=8/21/2009

Column B: Names
Example
B1=John
B2=John
B3=Jane
B4=John

Column C: Amounts.
C1=$23.52
C2=$14.85
C3=$54.78
C4=$9.84

How can I put this information into a chart and group the amounts into
months. For example, August for John would sum: $$33.36, but for Jane would
sum $0.00

Hi,
Select your information, Insert, pivot chart, then you can select from the
drop down list, which month or people

"GEM" wrote:

Column A: Dates
Example
A1=8/23/2009
A2=9/5/2009
A3=7/29/2009
A4=8/21/2009

Column B: Names
Example
B1=John
B2=John
B3=Jane
B4=John

Column C: Amounts.
C1=$23.52
C2=$14.85
C3=$54.78
C4=$9.84


How can I put this information into a chart and group the amounts into
months. For example, August for John would sum: $$33.36, but for Jane would
sum $0.00

But how can I group months together, add the amounts for each month and
present it as AUGUST, JUNE, JULY, SEPTEMBER, ETC.

"Eduardo" wrote:

Hi,
Select your information, Insert, pivot chart, then you can select from the
drop down list, which month or people

"GEM" wrote:

Column A: Dates
Example
A1=8/23/2009
A2=9/5/2009
A3=7/29/2009
A4=8/21/2009

Column B: Names
Example
B1=John
B2=John
B3=Jane
B4=John

Column C: Amounts.
C1=$23.52
C2=$14.85
C3=$54.78
C4=$9.84


How can I put this information into a chart and group the amounts into
months. For example, August for John would sum: $$33.36, but for Jane would
sum $0.00

Hi,
insert a column besides the one with the dates and enter the formula as follow

=month(A1)

this will give you the month number, now you will be able to choose only the
month needed

"GEM" wrote:

But how can I group months together, add the amounts for each month and
present it as AUGUST, JUNE, JULY, SEPTEMBER, ETC.

"Eduardo" wrote:

Hi,
Select your information, Insert, pivot chart, then you can select from the
drop down list, which month or people

"GEM" wrote:

Column A: Dates
Example
A1=8/23/2009
A2=9/5/2009
A3=7/29/2009
A4=8/21/2009

Column B: Names
Example
B1=John
B2=John
B3=Jane
B4=John

Column C: Amounts.
C1=$23.52
C2=$14.85
C3=$54.78
C4=$9.84


How can I put this information into a chart and group the amounts into
months. For example, August for John would sum: $$33.36, but for Jane would
sum $0.00

And how can I group dates into months in a Pivot Table???

"Pete_UK" wrote:

You'll need to produce a summary table, and then use that to drive
your chart (or by "chart" do your really mean "table"?).

List the individual names, eg in E2 down the column. In F1 you can
enter "JUL" (without the quotes), G1 can hold "AUG", H1 can hold "SEP"
etc, then in F2 you can use this formula:

=SUMPRODUCT((TEXT($A$1:$A$20,"mmm")=F$1)*($B$1:$B$ 20=$E2),$C$1:$C$20)

Adjust the ranges to suit (I've assumed 20 rows of data), then copy
across and down as required.

Another way would be to use a pivot table.

Hope this helps.

Pete

On Sep 8, 6:43 pm, GEM wrote:
Column A: Dates
Example
A1=8/23/2009
A2=9/5/2009
A3=7/29/2009
A4=8/21/2009

Column B: Names
Example
B1=John
B2=John
B3=Jane
B4=John

Column C: Amounts.
C1=$23.52
C2=$14.85
C3=$54.78
C4=$9.84

How can I put this information into a chart and group the amounts into
months. For example, August for John would sum: $$33.36, but for Jane would
sum $0.00

See Eduardo's comment, posted a minute before yours.

Pete

On Sep 8, 7:31*pm, GEM wrote:
And how can I group dates into months in a Pivot Table???



"Pete_UK" wrote:
You'll need to produce a summary table, and then use that to drive
your chart (or by "chart" do your really mean "table"?).

List the individual names, eg in E2 down the column. In F1 you can
enter "JUL" (without the quotes), G1 can hold "AUG", H1 can hold "SEP"
etc, then in F2 you can use this formula:

=SUMPRODUCT((TEXT($A$1:$A$20,"mmm")=F$1)*($B$1:$B$ 20=$E2),$C$1:$C$20)

Adjust the ranges to suit (I've assumed 20 rows of data), then copy
across and down as required.

Another way would be to use a pivot table.

Hope this helps.

Pete

On Sep 8, 6:43 pm, GEM wrote:
Column A: Dates
Example
A1=8/23/2009
A2=9/5/2009
A3=7/29/2009
A4=8/21/2009

Column B: Names
Example
B1=John
B2=John
B3=Jane
B4=John

Column C: Amounts.
C1=$23.52
C2=$14.85
C3=$54.78
C4=$9.84

How can I put this information into a chart and group the amounts into
months. For example, August for John would sum: $$33.36, but for Jane would
sum $0.00- Hide quoted text -

- Show quoted text -