LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 709
Default 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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
charting variable line data Richard Excel Discussion (Misc queries) 1 October 28th 08 09:03 AM
Inputting variable length data - outputting fixed character result Webster Excel Discussion (Misc queries) 2 October 26th 07 04:55 PM
How do I Add a variable in the legend without charting the data? Legends vs Plotting Charts and Charting in Excel 1 September 11th 06 08:00 PM
Adding "fixed" data to variable length data [email protected] Excel Worksheet Functions 3 February 16th 06 08:59 PM
Graph with variable data length snoach Excel Discussion (Misc queries) 1 May 27th 05 10:15 AM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"