![]() |
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 |
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