| View previous topic :: View next topic |
| Author |
Message |
melmoth
Newbie
Joined: 31 Jul 2005
Posts: 1
|
 Posted: Sun Jul 31, 2005 6:59 am Post subject: Graphs with two parameters |
 |
|
Hi,
could somebody tell me if, and how, it is possible to create three-dimensional graphs using OpenOffice Calc? And I don't mean the disguised bar charts marketing people use to make their presentations look flashier, but actually rendering a value z that is a function of two independent parameters x and y.
I.e. the spreadsheet
0 1 2 3
0 0 1 4 9
1 1 2 5 10
2 4 5 8 13
should give me a three dimensional view of a paraboloid.
If not, do you know of other ways to accomplish such a thing (i.e. in R? I don't have real math programs like Maple installed).
Thanks! |
|
| Back to top |
|
 |
9point9
Moderator
Joined: 31 Aug 2004
Posts: 3875
Location: UK
|
| Posted: Sun Jul 31, 2005 8:21 am Post subject: |
|
|
You can not do X-Y-Z graphs in OOo.
You will have to do proper maths in something like R, Gnuplot, Maple etc.
They are far more powerful programs, my QM lecturer liked to show off with 3d models of electron orbitals in Maple so it's possible.
_________________
Arch Linux
OOo 3.2.0
OOoSVN, change control for OOo documents:
http://sourceforge.net/projects/ooosvn/ |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sun Jul 31, 2005 8:47 am Post subject: Re: Graphs with two parameters |
|
|
| melmoth wrote: | I.e. the spreadsheet
0 1 2 3
0 0 1 4 9
1 1 2 5 10
2 4 5 8 13
should give me a three dimensional view of a paraboloid.
! |
There was a similar question posed recently that mentioned a piece of software add-in for Excel that did this sort of thing, perhaps; graphing discrete points in 3D. I don't know if Calc can handle it. However, you'd be better off with a more mathematical type of program for what you want. Spreadsheet functions are generally not designed for that purpose although they might give some limited approach to the problem. A freeware program called Winplot might suit your purposes if strapped for funds. It will plot discrete points, but it's arduous.
David. |
|
| Back to top |
|
|
|
