charting variable line data
 

Hi, I want to create a chart that has horizontal lines spanning different
x-axis co-ords for a certain y-axis co-ord.
e.g.
x-axis | y-axis
a:b 5
b:c 10
a:c 15

And i should have a chart that looks like:
15 |_____________
|
10 | ______
|
5 |______
|________________
a b c

excuse the crudeness of the pic...I hope the formatting works!

Does anyone know what this kind of chart is called?

And I can do it in a piecemeal way using a scatter plot and duplicating the
y-values. But my problem is that I have over a hundred series of data, and I
can't find any way of doing all 100 series at once.

Any ideas?

Thanks a lot
Richard

charting variable line data
 

Hi Richard,

Try Tushar Mehta's step chart at
http://www.tushar-mehta.com/excel/charts/step_chart/

Or Andy Pope's examples at
http://www.andypope.info/charts/stepchart.htm

Or have a look at my example at
http://www.edferrero.com/content/stepchart.zip

Ed Ferrero
www.edferrero.com