Which did you like, the surface chart? Note that every point in the X-Y grid
you see has to be entered with a real or interpolated Z value. If you don't
mind this step, these charts can be fairly effective, and I have used them
in the past. Excel's drawing of the surface is at best rudimentary, so often
I insert rows and columns into the sheet with more interpolations, just to
make the surface "fit" better. I actually have written about these chart
types:

http://pubs.logicalexpressions.com/P...cle.asp?ID=447

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"The chemistry student"
wrote in message ...
Hello,

Thanks for the help.
I will give more information. Regarding the dimensions, well, it is not
physical dimensions. It is chemical properties, melting points as a
function
of carbon chain length and saturation degree. The melting points are
dependent on both chain length and saturation degree so it could be
interesting to see the connection in a 3D chart. I suspect it's not
possible
in Excel but that I really want to do is to extract the equation from the
data sets just as one could do from a linear chart with two dimensions.

None of the three value sets is constant. The melting points vary, just as
the chain length and the saturation degree. So I don't see how I can
construct XY series and plot Z as a function of Y.

I saw one example of a nice 3D chart in the help menu, see
http://office.microsoft.com/en-gb/ex...346071033.aspx

Here none of the value sets seems to be continuous, but the chart looks
exactly as the one I want to do. Except that I have different units on the
axes of course.

Best regards

"Jon Peltier" skrev:

Excel has poor 3D graphics capabilities. Even when made with a program
with
"good" 3D capabilities, most 3D graphics are rather difficult to
interpret.
There have been attempts made to render an XYZ data set on a 2D chart
(see
http://andypope.info for a reasonably good one), but using trig and the
like
to simulate three axes. They may have been technically good, but still
difficult to interpret.

Are these physical dimensions? If not, the need for three pseudo-physical
dimensions is less important.

Is one set of X (or Y) values continuous across the chart? Then you could
construct XY series where each series represents a constant X value, and
you
plot Z vertically as a function of Y.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"The chemistry student" <The chemistry
wrote in message
...
Hello,
I want to make a chart with one series and 3 coordinates/values
(y,x,z),
this means one value is dependent on two variables. So I have three
types
of
data in three columns, and I want to visualize their relationship in a
3D
chart with three axes. If I try with the 3D chart function I get 3
series
in
parallel. It is not that I want. How do I do it?

Thank you.