|
PureBytes Links
Trading Reference Links
|
in excel, menu option data, pivot table, select all default, drag each of
the columns to the various locations in the pivot table as described below.
rgds,
ah
-----Original Message-----
From: Aaron Schindler [mailto:aaron@xxxxxxxxxxxxxxxxxxxx]
Sent: Friday, March 14, 2003 11:38 AM
To: Leslie Walko; Omega List
Subject: Re: Excel question
To make a 3D plot in Excel the data must be arranged in a table. X values
across the top, Y values running down the side, and the Z values filling the
cells of the table.
Aaron
----- Original Message -----
From: "Leslie Walko" <l.walko@xxxxxxxxxxx>
To: "Omega List" <omega-list@xxxxxxxxxx>
Sent: Thursday, March 13, 2003 6:55 PM
Subject: OT: Excel question
> Please help the Excel challenged!
>
> Given 3 columns of data, columns X, Y, and Z,
> how do I plot a 3 - dimensional surface topology chart?
>
> I've seen this so many times in books,
> yet whenever I invoke the Excel 'Wizzzard',
> it does not seem to let me make such a 3-D plot.
>
> Can a real Wizard offer some hints?
>
> Thank you,
> --
> Regards,
> Leslie Walko
> 610-688-2442
> --
> "Life is a tragedy for those who feel, a comedy for those who
> think"
> Horace Walpole, 4th earl of Orford, in a letter dated about 1770
>
>
|