Charts.

G

GEM

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
 
P

Pete_UK

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
 
E

Eduardo

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

GEM

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

Eduardo

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
 

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