ExcelBanter - 3D charts

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - 3D charts (https://www.excelbanter.com/charts-charting-excel/190531-3d-charts.html)

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.

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.

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

--
--
@+
;o)))

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 its 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 dont 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.

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.

On Tue, 10 Jun 2008, in microsoft.public.excel.charting,
The chemistry student
said:
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 its 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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.