3D charts

[The chemistry student]

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.

 

[Jon Peltier]

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

 

[Andy Pope]

Hi,

Excel does not do true 3d plots. You can mimic it though with formula.
http://www.andypope.info/charts/3drotate.htm

Cheers
Andy

 

[Mais qui est Paul]

Bonsour® The chemistry student avec ferveur ;o))) vous nous disiez :

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?

Why not experiment with bubbles charts ?
or
http://www.prodomosua.eu/zips/isometrixsetup.zip
http://www.prodomosua.eu/zips/sphere.xls
http://www.prodomosua.eu/zips/3d.xls

 

[The chemistry student]

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/excel/HA010346071033.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:

 

[The chemistry student]

Thanks, I think I can use this formula.

Cheers

"Andy Pope" skrev:

 

[Jon Peltier]

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/Pub0009/LPMArticle.asp?ID=447

- Jon

 

[Del Cotter]

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.

What are the chain lengths? Are they long or short? If short, then
you're talking about discrete integers anyway. What is the measure of
degree of saturation? Won't you give an example?

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.

It's quite possible in Excel to get a regression in multiple unknowns,
you just have to find the fit that gives the least square deviations.