Hello,
I have the following question regarding excel and I was hoping someone out here could help me:
I want to make a graph with years on the x-axis and an amount on the y-axis. I have dataset consisting of two columns. One of the two columns (A) is a date (f.e. 14 March 2001) and the other column (B) contains number (f.e. 1).
Here comes my problem: For each year in my dataset I want to have the total of column B as a datapoint. Because my dataset is to large to manually add all the datapoints per year I am looking for some way to add datapoints belonging to a certain year.
So for example, this is what I have:
Date (A)--> Amount(B)
12-02-2005--> 1
05-05-2005--> 2
06-04-2006--> 3
06-05-2006--> 4
06-03-2006--> 5
01-01-2007--> 8
Now I want to show this in a graph, which is similar to the following table:
Year (x axis)--> Total Amount (y axis)
2005--> (1+2=) 3
2006--> (3+4+5=) 12
2007--> 8
Thank you for your help!
Regards,
Edward
Bookmarks