Is plotting 2 columns of data on one line possible?

[meaganmaguire]

I am trying to reproduce a visual that I created before, however, the formatting of my data has been requested to be streamlined and easier for automatic updates. My original data and visual looked like this:

Now my data must look somewhat like this where an initial and final value are together on one row instead of separate rows. Will it even be possible to reproduce the visual? The only way I can imagine it working is if Excel reads in a zigzag way down C and D.

[#2]

@meaganmaguire I would use a couple of helper columns and then use the opportunity to create Names for those columns so the plot will automatically update.  I also 'Formatted as Table' the orginal data table and called it Data

so the year column would be:

=TOCOL(HSTACK(Data[Date],Data[Date]))

and the Specific Capacity is:

=TOCOL(Data[[SCi]:[SCf]])

 Then in the Names section I defined:

Plot_Year = 'Plot data'!$A$2#

Plot_SpecCapacity = 'Plot data'!$B$2#

then the plot uses those names