I'm currently creating Charts dynamically with a mixture of Columns and Lines.
I have two lines in this particular chart 1. Cumulative Total (CT) and 2. Forecast Cumulative Total (FCT).
What I'm trying to achieve is, for this financial year we calculate our "CT" up to the current month/year and anything after that we calculate our "FCT".
How do i get these lines to match as the end of the period of the "CT" and start of "FCT".
I have attached an example that i can easy do in Excel.