I need to create a line chart where there will be a link (vertical line) between data points of two lines in a single chart

[Anonymous]

I need to create a line chart where there will be a link (vertical line) between data points of two lines in a single chart. PFA the sample image. Please let me know the possible way...it an urgent requirement.

[jonathandienst]

The simplest that comes to mind would be a stacked combo chart with two lines and a bar.

Line1 = value of data point 1

Line 2 = value of data point 2 - data point 1

Bar value = value of data point 2 - data point 1;

Bar offset = value of data point 1

[jonathandienst]

Or play around with the box plot and a couple of lines. I am not sure if you can stack those on a single chart though...

[Anonymous]

but  then bar width will be more than a normal thin line.. i have changed cluster distance to 8...still its not a thin line