I have data arranged as following:
What I'd like to do is create a graph that looks something like the following (which I generated with graphics software):
So, for example, to generate the first line, cell B1 is the start time and cell B4 is the value at the start time. Cell B2 is the end time and cell B3 is the value at the end time. Between them is the line. Then repeat for each column.
Is this possible? And, just as important, is it possible without restructuring how the data series is structured in the spreadsheet?