Charts.

  • Thread starter Thread starter GEM
  • Start date Start date
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
 
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
 
Hi,
Select your information, Insert, pivot chart, then you can select from the
drop down list, which month or people
 
But how can I group months together, add the amounts for each month and
present it as AUGUST, JUNE, JULY, SEPTEMBER, ETC.
 
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
 
Back
Top