Hi everyone, I would like to know how to create a 3D graph with 3 coordinates, i.e., with a table of 3 columns (x y z), if possible, in Excel, please! Thank you. See you! ;))

3D Chart in Excel : CCM

Réponse 1 / 9

MyStyle

Here is a tool simulating 3D... very well done:

https://andypope.info/charts/3drotate.htm

Bluetiger089

Hi,
Thanks, I think your link will help me a little with what I was looking for....
I'll try to adapt it to my needs.
Then I'll let you know what happens.
See you later! :-)

Réponse 2 / 9

foobar47

WhitFang, with all due respect to you, as well as to everyone else for that matter, I feel, while consulting your posts, that you see people as fools!!! ;)))
It's not meant to be mean, but if I'm asking the question, it's because I truly need it.
Don’t take it the wrong way, especially! :)))
Come on, help me instead! ;))
Thanks.
No but seriously, are you saying that because it's too easy to do or because it's impossible!?
Thank you.

PS: I'm not used to saying nonsense, you just have to look at my contributions, they are far from being worthy of an expert like you, but they are certainly not ridiculous either.
Catch you later ;)))))))

Réponse 3 / 9

foobar47

Also, I'm butchering your nickname!!! ;)
Thousand apologies!
;)

WhiteFang Posted messages 2063 Status Membre 204

;-)

No no, you’re mistaken, I don’t take anyone for a fool… It might be my way of writing or expressing myself, but that idea is far from me…

I teach and I’m also a dad of grown children, it’s possible that over time, my way of expressing myself has been affected by this!! The “teacher” and “dad” side!! ;-))) But no, don’t believe that, and worse than me in self-reflection, it's tough!!

And in the future, if you read my posts, read them with that in mind… And your question makes me happy, because instead of judging and imagining things, you ask the question, cool, and thank you ;-)) Don’t forget one thing about me: I love to poke fun at myself, I don’t take myself seriously, and when it comes to joking around, I’m not the last one to join in… And the more we know, the more we realize we know nothing at all, and that’s what’s terrifying!! Just imagine getting older!! Laugh…

So, do you know me better now? ;-))

No, definitely not, I would never think of taking people for idiots (even though some are, their life path might lead us to understand why…)… Except that sometimes, I have my playful/teasing side that wakes up… ;-)) Just to play the role of the brain booster… ;-))

Hi!

;-)
Wild and Free

WhiteFang Posted messages 2063 Status Membre 204

;-)

As for the answer to your question, well, I would tend to say it's a bit too easy... ;-)))) That's why, my response to this post... A milligram of personal reflection (still my "teacher" side), and there you go, especially with the assistants... No need for any ccm for that... And a good "think about it!" doesn't hurt, when it's nice....

;-)

Wild and Free

Réponse 4 / 9

marine

Hello,

I just came across your question and I have the same issue...
Have you found a solution???
Do you think MATLAB or Maple could work??
I'm stuck, without this graph I'm at a standstill.

Thank you
Marine

Ha d'Oc

Yes, it's possible.

With an appropriate macro package.

https://www.xlstat.com/en/solutions/3d-plot

However, it costs veeeeeery expensive

But there might be a trial version.

Réponse 5 / 9

Raymond PENTIER Posted messages 58550 Registration date Status Contributeur Last intervention 17 475

... but in English!
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂

Kev

Hi everyone,

To plot 3D graphs with numerical values in X, Y, and Z you can use ORIGIN (Microcal Origin)
Version 5 is very lightweight, no installation required...
Then you just need to put the values in column format and do "set as" (X or Y or Z)... After that, do "plot" and "3D charts" then "wall" or "waterfall" and if you have only one curve "trajectory"...
With that,

See you later

(if you have better, I'm open to suggestions)

Raymond PENTIER Posted messages 58550 Registration date Status Contributeur Last intervention 17 475 > Kev

Hello and thank you.
But I didn’t find the website that talks about it on Google...
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂

gnu > Kev

The best software for plotting 3D (and 2D as well) curves is undoubtedly GNUPLOT.
It can be used on Linux as well as on Windows.
See you!

Daranc

ceci en anglais
http://yallouz.arie.free.fr/excel/excelsurface.php

Réponse 6 / 9

Kcr Posted messages 1 Status Membre 3

There is a ready-made tool for tracing 3D curves (trajectories), see TriaXExcelPro at www.kopoos.com (completely independent of Excel, no macros to install). This tool reads data from Excel and visualizes it live. It even does more than just 3D, for example, 3DD (dynamic, also called 4D) to take into account temporal events to be visualized...

Réponse 7 / 9

guest

Matlab does the job for example:
you initialize your Z
then
[X,Y] = meshgrid(1:1:7, 5:10:195)
then
surf(X,Y,Z)

Réponse 8 / 9

WhiteFang Posted messages 2063 Status Membre 204

;-)

Otherwise, if you want to chew it over, you select your data area, copy it, insert a graph sheet, and paste it. By the way, you would have chosen a 3D graph style, either "radar" or "surface," but there, it's cheating since I've chewed the work for you!! ;-))))

;-)

Wild and Free

Réponse 9 / 9

WhiteFang Posted messages 2063 Status Membre 204

;-)

Is your question serious?

;-)

Wild and Free

3D Chart in Excel

9 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.

Wake on lan with livebox

"freebox" is blinking (tv)