Connecting points in a graph

Ok, its was a bit difficult as all the value are plotted with calculated values from various sheets. Here's the sample. What i would like to achieve is the one with the blue line. The caps and the point itself has to have a parallel line till it almost reaches the next range. X-axis is the range.