I am attaching a link of tweaks I made to the previous version you sent.
I also added a separate 'originating data' series to correctly calculate TCO
I used IF statements to set different data is the 'other' is positive or negative.
I still cannot change the label of TCO of the right graph, it is stuck on £52,500 no matter what.
The version you just sent me also has this problem TCO stuck at £52,500 (also I changed 'other' to a positive figure) it did not chart well, have a try
I still don't understand how you actually format "no-line", "seen-line". Let's take 'line 2' as an example, it is 5 data points, so 4 'in between' lines. We want line 1,3,4 as 'no-line' and line 2 as 'seen-line' how do you get access to each of these lines to tweak the formatting (I want to do it my self but cant figure it out)