ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   charting variable length line data (https://www.excelbanter.com/charts-charting-excel/208038-charting-variable-length-line-data.html)

Richard

charting variable length 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







Richard

charting variable length line data
 
formatting of the graph pic didn't work....
what i was trying to show was
the bottom line on the graph (y-value=5) goes from x=a to x=b
the middle line on the graph (y-value=10) goes from x=b to x=c
the top line on the graph (y-value=15) goes from x=a to x=c

all lines are horizontal

thanks!


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com