Thread: Charts.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Charts.

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