Dumbbell Chart issue - How to organize data and make it work?

Hi,

I am trying to create a Dumbbell chart and i am having some issue with it.

I got data from source in this format:

Using the above data, i wasn't able to convert it into a dumbbell chart, so i modified/pivoted data like this:

even after pivoting the data I am unable to get dumbbell chart. In the below pic i tried to define a path, not sure where i am going wrong. Please guide me here.

Desired Output:

Please find the attached Excel data as well as attempted dumbbell dashboard.

Thanks & Appreciate anyone's help in this regard.