Forum Discussion
Tracking line graph
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.