View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.charting
spazminator
 
Posts: n/a
Default I need more general XY point to point plotting than XY scatter

All this because I was so silly as to create a dataset from scratch which
seemed simple, but unfortunately not representative. The lines I want are
neither horizontal nor vertical nor lined up neatly in any way whatsoever. So
error bars won't do.

Nor did Mr. Shorty's solution produce an elegant result. The global picture
here is that XY-Scatter plots are sickeningly single purpose, with no thought
for general use. Who will and create a better solution? Apparently not MS.
I'm back to drawing plots with gp programming languages.

--
lostinamazeoftwistyturnypassagesallthesame


"B. R.Ramachandran" wrote:

Hi,

The Error-Bars approach (Method 2 in my previous reply) would work only if
the lines are horizontal (zero slope). If it is not the case, you have to
plot each group (two points) as a separate series (Method 1)

If the lines are horizontal, but the lines don't start on the Y-axis,...