0
1
I have data that looks like this:
Actual End Date ----CP 2016-04-22------------4 2016-04-26------------3 2016-04-26------------9 2016-04-22------------7 2016-04-26------------6 2016-04-26------------2
What I need to do is to group these dates per week in a line graph, and add up the CPs for each week. I have researched about pivot tables and charts, which makes grouping dates much easier. But I don't want another table to show these values. These data are written to Excel through Apache POI. If I were to use pivot table and chart, I want it to be automatically updated every time Apache POI writes to the file.
So, how can I plot these dates (in a 7-day interval) in a line graph and at the same time add up those CPs per week?
I could really use your help. Thanks a lot!
EDIT: I am using this formula:
=SUMIF(WEEKNUM(D5:D10),WEEKNUM(D5:D10),E5:E10)
But clearly it is wrong. Basically, what I want to do is to sum up values with the same weeknums. Any ideas?
Welcome to Super User. New members commonly mistake this for a service site where we will do the work. It is a Q&A community where specific questions are asked after you have attempted something and get stuck. Please add details of what you have tried so far, including scripts, code or formulas, and we will try to help. If you need more info about asking questions, check out *[ask]* in the *[help]*. – CharlieRB – 2016-04-27T15:08:42.323
Thanks @CharlieRB! I have been stuck with this task and would really need some advice. – Lota Joanna – 2016-04-28T02:53:48.700