Sorry for asking a question more for a StupidUser than a Superuser but I'm at my wit's end.
I have one column of dates (x-axis values), and one of transactions (y-axis values).
Date Amount
3/5/2017 665.16
3/6/2017 -100.00
3/6/2017 -35.66
3/6/2017 -9.24
3/6/2017 -26.32
3/6/2017 -56.70
3/7/2017 -7.72
3/7/2017 -5.78
3/8/2017 -11.00
3/8/2017 -129.00
...
I want to chart this data so that I can see how the total changes over time. So for example at 3/5/2017 the data point is at 665.16, and then at 3/6/2017 it's 437.24 (665 -100 -35.66 -9.24 -26.32 -56.70)
I haven't even been able to get the raw numbers in the chart, nevermind the running total. I tried by highlighting the two columns, selecting "Insert Waterfall Chart", but I haven't been able to get the data to actually get into the chart correctly.
I've also tried using a pivot chart, hoping its supposedly more-advanced features would let it intuit what I wanted the data to be, but no luck there either. I was able to get it to show the count of transactions on a given day, but not to sum them, even by changing "Count of Amount" in Values to "Sum of Amount".
I'm pretty sure it's excel 2016, but I couldn't even find the About entry in the menu so if you tell me that I can find out for sure.