How do I create a real S-Curve?

I want to create an S-Curve chart. 

Each month has a dollar amount, and each amount can be added to the previous month to give a grouped running total. 

My dataset contains a large number of projects, and a large number of months, and the dollar amount for each. 

The monthly dollar amount is a column. The cumulative amount is a line. Both on the same chart, and obviously there must be two vertical axes. 

So... The cumulative amount can be calculated with a whole heap of code and functions (unlike SAP or Excel which just do it with a single formula), but the graphs don't work. 

Option 1: The standard "line and stacked column" - FAIL. 

The Shared timeline is the whole dataset. So if a particular project has only got three rows of data, the date range will still be selected from all 1 million rows.  

Option 2: line and stacked column chart with table - FAIL

There is no option to have a seondary axis. So the data is not even visible. 

Option 3: Line and Clustered Column - FAIL

Same as option 1. 

Sorry for my obvious frustration, but this is just soooo painful.