View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default 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