Here is some sample data (csv):

name,X1,Y1,X2,Y2
A,0,0,2,0
B,0,1,2,1
C,0,2,2,2
D,0,3,2,3

I want to show line segments only between A-X1-Y1 and A-X2-Y2; B-X1-Y1 and
B-X2-Y2 etc, NOT between A-X2-Y2 and B-X1-Y1 or B-X2-Y2 and C-X1-Y1 etc. It
would be cool if the A, B, C, D labels could be visible on the graph, and
even better if I could then paste like data onto the chart, even using paste
special and have it conform, but I've tried many times without success. It
always messes up the new source data with wrong assumptions. Try it.

--
lostinamazeoftwistyturnypassagesallthesame


"MrShorty" wrote:


Can you be more specific as to what you need? I've never had any
trouble plotting an XY plot and having the data points connected by
straight lines. Normally either select the "connected by lines" option
when the chart is created, or select the data series Format-selected
series-patterns tab-select the desired line style to connect the
points.

I almost never use the paste command to add a data series to an
XYchart. I will either use the paste special command (which allows me
to specify that I'm using new or different X data) or use the
Chart-Source data-Series tab to add a data series.

If that doesn't help, then post again with more details about the
problem you are having.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=493208