Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting a variable range | Charts and Charting in Excel | |||
In-line charting | Charts and Charting in Excel | |||
defining a variable-size worksheet area for charting | Excel Worksheet Functions | |||
How do I Add a variable in the legend without charting the data? | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |