Two vertical axes line graph

[Moeslate1]

I need to show overall trends with state data that have different beginning years and the same end year (2014). My goal is to have two vertical axes, one that is labeled "Start Year" and the other labeled "2014," with a line for each state's data. Each line will correspond to a state, and I would like the state name to be listed next to its starting point left of the "Start Year" axis. There should be 28 lines in total, all beginning on the START Axis and ending on the 2014 Axis. The data is:

State	Start	2014
Arizona	48.9	48.9
California	87.2	109.7
Colorado	17.2	90.6
Connecticut	10.6	70.1
Delaware	40.4	87.5
Hawaii	0.0	116.2
Illinois	0.0	45.2
Kansas	103.0	103.0
Maine	7.6	62.3
Maryland	36.1	95.0
Massachusetts	73.8	65.1
Michigan	111.4	111.4
Minnesota	83.8	83.8
Missouri	79.2	79.2
Montana	98.4	98.4
Nevada	-108.0	60.2
New Hampshire	103.7	103.7
New Jersey	31.0	80.3
New Mexico	81.2	77.9
New York	207.0	215.6
North Carolina	60.2	60.2
Ohio	136.2	121.1
Oregon	87.0	87.0
Pennsylvania	100.9	95.0
Rhode Island	92.0	92.0
Texas	45.2	53.1
Washington	76.8	76.8
Wisconsin	1.5	50.0

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Any recommendations for how to create this?

 

[Moeslate1]

Also, there should be nothing on the x-axis

 

[thisoldman]

The graph you want is called a slope chart. Both Jon Peltier and Stephanie Evergreen have tutorials.

Jon Peltier—
http://peltiertech.com/slope-graphs-in-excel/

Stephanie Evergreen—
http://stephanieevergreen.com/slopegraph/

 

[Jon Peltier]

How are you going to rationalize the different starting years? The slope of the line in a slope graph provides as much information as the endpoints of the line. You even have some cases where the two values are the same (KSD, MI, NH, etc., in fact 40% of them): does this mean that there has been no change (in which case you should plot a horizontal line), or that the only data point you have is the value for 2014 (in which case you should only plot the point for 2014 and no line)?

Unless you have consistent start and end points, a slope graph will not show the data clearly. It will distort the slopes, giving an incorrect comparison of changes between states.

This is something you need to think about before committing this data to a chart.