Pivot Chart Running Total With Year / Month And Day On X Axis

I have a set of data with values and dates (call the dates 'raw dates'). I have added 3 columns with formulae in them as follows:

Year =YEAR('raw date')
Month =TEXT('raw date',"mmm")
Day ='raw date', formatted as "d".

I have a pivot chart with three Axis Fields. In order they are: Year, Month and Day. This is so that the chart itself has three layers of x-axis names (year, month and day) rather than a whole load of dates which looks messy.

I would like to show the values as a running total "in" the raw dates of the data.

When I show the values as "Running Total in" 'raw dates', I get a load of #NAs in the pivot table because the raw dates are not in the Axis Fields. If I select Running totals "in" the Days (which is included in the pivot table setup), I get running totals over each month, starting at zero on the first date in each month. I need to have the running total run over the course of the whole data set, not mini running totals in each month.

When I choose only the 'raw dates' in the axis fields (i.e. taking out Year, Month and Day), running total works fine. The only thing is that I lose the nice looking x-axis. Adding the raw dates to the other 3 Axis Fields also doesn't work - it doesn't even try to give a running total at all, just the original values.

how to achieve a running total without sacrificing the x-axis?