Line Graph: Cumulative earnings

Discussion created by jbrown Expert on Sep 24, 2012
Latest reply on Sep 24, 2012 by comment

At my school, the kids earn money each week, fake money that they use to apply towards school supplies and towards end-of-trimester field trips like skating or bowling.

I haven't figured out a way to create a line graph. I'd like the X axis to be each week, and the y axis be their cumulative earnings for the trimester. If a kid earns $8 the first week and $10 the second week, how could i create a line graph that shows $8 and then $18 (week 1 + week2)? There seems to be a way; I just can't find it.


PS. Each advisor deposits the amount into the database. Each week its deposited, a week number is calculated. Entering the deposit on 9/24 would give us a school week of 6. So the students right now have 6 deposits in the system and each is marked by a week: Week 1, 2, 3, and so on.

That keeps each week separate allowing me to do things with the data.