Plotting a XY scatter plot without having an XY column

[DennyP]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello
I want to plot flux(Y) against pressure (X) but my presentation of the data in the spreadsheet is not columns. Rather separate cells scattered across the sheet.
Is there a way to plot an XY without arranging the data in an XY column format?
Thanks
Dennis

 

[John McGhie]

No

But you can use formulas to replicate the data into a table, which can be on
a different sheet, or hidden.

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hello
I want to plot flux(Y) against pressure (X) but my presentation of the data in
the spreadsheet is not columns. Rather separate cells scattered across the
sheet.
Is there a way to plot an XY without arranging the data in an XY column
format?
Thanks
Dennis

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]