Creating horizontal line chart with categories in y-axis

**riya.arora.** · 04-09-2013, 03:33 AM

Hi All,

I am facing problem in creating a line chart such as:
1. The categories should appear in y-axis
2. The Range 0-100 should appear in x-axis
3. The two values of each category should be linked with a line.

I have attached a sample excel with data and the required chart.

kindly help in plotting the graph.

Early solution is most appreciated.

Warm regards,
Riya

**Andy Pope** · 04-09-2013, 04:10 AM

You can use a combination bar and xy-scatter.

Bar series provides category labels on the Y axis.
2 xy-scatter series provide the dots. Use custom positive X error bar to join the dots.

**riya.arora.** · 04-09-2013, 04:48 AM

Bravo Andy!!

Thanks a tonne. 80% of the problem is resolved but still I am unable to get the black lines joining the two points.

Can we enhance the solution lil bit?

Warm regards,
Riya

**riya.arora.** · 04-09-2013, 04:53 AM

Hey!!! got it.

Thank you very much for the solution!!

I am glad meeting best people in excel

**Andy Pope** · 04-09-2013, 04:55 AM

Add error bars to Pooriest series.
Set error bars to be plus, using custom values which are calculated on the sheet.

See here for more information on error bars
http://peltiertech.com/WordPress/err...in-excel-2007/