Forum Discussion
Tracking line graph
Hi kentleywiltshire4 ,
Could you please send a sample of you file? You can populate it with fake data. I'm just trying to find a solution for it, but I will have to check how you organize your entries.
Just to confirm: you want the line chart to present the cumulative totals from each day? So if you got a total savings of 100 in Jan 31st and a total savings of 50 in Feb 2nd, you want the line chart to present Feb 2nd as 150, correct?
If yes, you first have to transform your savings column in numeric data (right now it is as text, at least in the file that you sent) and summarize the entries by day. You can do this by using a pivot table or the UNIQUE function connected to a SUMIF (example of the attached file).
Please, confirm if my assumptions are correct and let me know if the file that I sent you is in the right direction for solve your problem.
Yes correct, cumulative is the idea.
Your attachment is similar to what I need but not quite. See below example pic of what I had in mind...
This would be simpler if all data was fixed. But instead data for each row will be moving every day. I was thinking if excel was able to snapshot how much has added onto the total each day at the end of the day that would give me a daily figure.
I'll try your suggestions and try and make it work. Thanks
I'm not sure, but I believe that Excel is not able to snapshot any data and register only the changes. Considering the file that your shared, I'm afraid that it will be very difficult to catch these changes with the current Sheet structure.
If you have the option to modify the workbook structure, maybe it will be helpful to catch these changes.