Re: I need more general XY point to point plotting than XY scatter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Exactly... can be done but not readily... reformat your data...
I think MS with just a little thought could add a new chart type that would
be a lot more conducive to "pen plotting". Like allowing a pen-up/pen-down
column or something. Also it seems to me that the default of assuming the X
column in an XY scatter plot is going to be the same for each new series --
is just busted.

I hate that charting in general is so geared for accounting and
presentations and so limited for engineering or science uses.
Why isn't there a 3D XYZ scatterplot chart type for instance?
Why does one have to buy/load/install extensions for mathematical analysis?

I will try your point-per-line idea though. It looks like the best solution
so far. It's just that there are a lot of points and I need them in the
current format for other reasons on the ***. Looks like I'll be adding a
new work*** for the chart.

Thanks for trying.
--
lostinamazeoftwistyturnypassagesallthesame


"MrShorty" wrote:

>
> Others may have better ideas, but it seems to me your data aren't laid
> out in a format conducive to what you want. I was able (using the
> "source data" dialog I mentioned above) to get a plot that looks like
> what you describe. I had to select each individual point separated by
> commas within a given series. The final series definition looked like
> =SERIES(Sheet1!R5C1,(Sheet1!R5C2,Sheet1!R5C4),(Sheet1!R5C3,Sheet1!R5C5),4).
> That, of course, isn't conducive to readily adding points to a
> series, or adding series to the chart. Can be done, but not readily.
>
> If you lay your data out differently, it would be easier. Try a lay
> out where the X data are in a column and the corresponding Y data are
> in the adjacent column. Something like:
>
> name A A B B C C D D (names doubled to emphasize column relationship)
> axis X Y X Y X Y X Y
> pt1 0 0 0 1 0 2 0 3
> pt2 2 0 2 1 2 2 2 3
>
> Then it's easy to add data points (simply add rows) and data series
> (simply add pairs of columns going across and paste special) to your
> chart.
>
>
> --
> MrShorty
> ------------------------------------------------------------------------
> MrShorty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22181
> View this thread: http://www.excelforum.com/showthread.php?threadid=493208
>
>
.

Quantcast