Hi,
I attached an example (with random data) of the problem I fail to resolve.
The Data Sheet has data sorted by dates running from 1 Jul 17 to 28 Feb 18.
In the Cash Flow Projection sheet I wish to display accumulated estimated outflows compared to accumulated estimated inflows over the relevant period of 8 months in a simple line chart. For this I used "Running Total In" on the "Show Values As" tab under the "Value Field Settings" to give me the accumulating data values.
I get it to display correctly from Jul to Dec, but it starts calculating anew from Jan to Feb. The chart shows what I mean.
I have fiddled around, but cannot seem to get it right. One option was to remove Years from the Axis, but then Jan & Feb 18 shows before Jul to Dec 17 on the chart that confuses a viewer.
Could some kind person please point me to what I fail to see/do?
Thank you kindly.
A
Bookmarks