Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Plotting a XY scatter plot without having an XY column

0 views
Skip to first unread message

Den...@officeformac.com

unread,
Dec 28, 2009, 11:37:24 PM12/28/09
to
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

unread,
Dec 30, 2009, 7:56:14 PM12/30/09
to
No :-)

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


On 29/12/09 3:37 PM, in article 59baf...@webcrossing.JaKIaxP2ac0,
"Den...@officeformac.com" <Den...@officeformac.com> wrote:

--

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:jo...@mcghie.name


0 new messages