I have a list of values with an amount and a date.
I would like to display it like a stacked (?) bar chart where each value is marked with its own box, and then displayed on the corresponding day – adding up to the total for each day.
I understand there might be a few manipulations needed of the table, but am not good enough in Excel programming to figure out how to do this. The example table is small enough to allow manual sorting, but ideally I'm looking for a solution that also work with large tables.
Here is a different answer that is very similar: Create a stacked bar chart that displays data in monthly intervals?
but that example uses months instead, and I can't seem to crack how to get it to work with days in my table...